Rule “Valid DSN” and Rule “Valid Database compatibility level and successful connection” failed.

-> I was performing an In-Place upgrade from SQL Server 2014 to SQL Server 2016.

-> Below rules failed,

Blog91_1

-> Rule Check 1 -> Valid DSN

Blog91_2

—————————
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

Blog91_3
—————————
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,

Blog91_4

Blog91_5

Blog91_6

Blog91_7

Blog91_8

Blog91_9

Blog91_10

Blog91_11

Blog91_12

-> Refresh the SQL Server 2014 rule window again and it will succeed this time,

Blog91_13

-> 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.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s