-> I was performing an In-Place upgrade from SQL Server 2014 to SQL Server 2016.
-> Below rules failed,
-> Rule Check 1 -> Valid DSN
—————————
Rule Check Result
—————————
Rule “Valid DSN” failed.
The report server configuration is not complete or is invalid. Use Reporting Services Configuration Manager to verify the report server configuration.
—————————
OK
—————————
-> Rule Check 2 -> Valid Database compatibility level and successful connection

—————————
Rule Check Result
—————————
Rule “Valid Database compatibility level and successful connection” failed.
The report server database is not a supported compatibility level or a connection cannot be established. Use Reporting Services Configuration Manager to verify the report server configuration and SQL Server management tools to verify the compatibility level.
—————————
OK
—————————
-> SQL Services Reporting Services is installed, but not configured and it seems like thats the reason for this issue.
-> I configured SQL Services Reporting Services as below,
-> Refresh the SQL Server 2014 rule window again and it will succeed this time,
-> This allowed me to complete the upgrade without any further issue.
Thank You,
Vivek Janakiraman
Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.