Troubleshooting When you upgrade SQL Server when you encounter a [report server database is not in a supported compatibility level or cannot establish a connection] rule validation does not pass the issue

PS: Title is a bit long ...

When you upgrade SQL Server R2 to SQL Server 2014, you encounter the following rule validation errors:

Rs_validdatabaseversion

Check that the version of the report server database can be used by a Microsoft SQL Server 2014 report server.

Failed

The report server database is not at the supported compatibility level or the connection cannot be established. Use Reporting Services Configuration Manager to verify the report server configuration, and use SQL Server Administration Tools to verify the compatibility level.

The specific information may be: Valid database compatibility level and successful connection * * * what.

Workaround:

1. Check that the reporting service is turned on: View the SQL Server Reporting Services service;

2. If it is turned on, open the Report service Reporting Services Configuration Manager, click "Database" after connecting,

View the SQL Server name in the current report server database, and attempt to specify the name of the database name by connecting

's database. If you are not connected, you need to click Change Database, select "Select Existing Report * *" to connect to the desired database.

Or you can create a new database.

3, if the above are done, or not, please leave a message to me.

Troubleshooting When you upgrade SQL Server when you encounter a [report server database is not in a supported compatibility level or cannot establish a connection] rule validation does not pass the issue