Resolved Error “Upgrade Error - Valid Database compatibility level and successful connection rule”

kumkumsharma

Administrator
Staff member
When we try to upgrade your SQL server then sometimes it throws below error.

Code:
"The report server database is not a supported compatibility level or a connection cannot be established."
Sometimes the reason of this error is SQL Server name which was no longer existed in Reporting service configuration manager that this caused the issue in validation rule. So to resolve this error we have to change the SQL Server name to current SQL server name so that validations can be passed successfully.

You can follow below steps to change SQL Server name in Reporting services configuration manager:
  • Navigate to Start >> All programs >> MSSQL Server 2008 R2 >> Configuration Tools >> Reporting services configuration manager.
  • You will find Reporting services configuration connection window where you have to click on “Connect” button.
  • Now select “Database” tab and click on “Change Database” button.
  • Now choose an existing report server database by selecting radio button and after that click on “Next”.
  • You have to enter correct SQL Server name and click on “Test Connection” button.
  • Now your Connection will be successfully established.
 
Top