Valid Database compatibility level and successful connection rule

Upgrade Error - Valid Database compatibility level and successful connection rule

 When you try to upgrade SQL Server 2005 to SQL Server 2014, you might encounter with the following error

"The report server database is not a supported compatibility level or a connection cannot be established."


SQL Server 2014 Support for SQL Server 2005 
  When a SQL Server 2005 database is upgraded to SQL Server 2014, the database compatibility level will be changed from 90 to 100. (In SQL Server 2014, valid values for the database compatibility level are 100, 110 and 120.) 

  ·         Upgrade a SQL Server 2005 instance of database engine to SQL Server 2014 by running SQL Server 2014 setup using the installation wizard or from the command prompt.

·         Attach a SQL Server 2005 database (mdf/ldf files) to SQL Server 2014 instance of database engine.

·         Restore a SQL Server 2005 database to SQL Server 2014 instance of database engine from a backup.

·         Upgrade a SQL Server 2005 Integration Services (SSIS) package to SQL Server 2014. Execute packages with automatic-in-place upgrade.

·         Upgrade a SQL Server 2005 Analysis Services (SSAS) to SQL Server 2014 by running SQL Server 2014 setup.

·         Back up a SQL Server 2005 Analysis Services (SSAS) cube and restoring on SQL Server 2014.

·         Upgrade SQL Server 2005 Reporting Services (SSRS) to SQL Server 2014 by running SQL Server 2014 setup.