Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version Tonight we upgraded our SQL Server 2012 (SP2+CU6) cluster with SQL Server 2014 Service Pack 1.

On that cluster nodes, we have Native mode Reporting Services scale-out configuration.

After in-place upgrade to SQL Server 2014 SP1, we got error from Reporting Services web page:


  The version of the report server database is either in a format that
  is not valid, or it cannot be read. The found version is '163'. The
  expected version is '162'.


So there go question - why we have this error when we have upgraded to the most recent version of SQL Server 2014 and Service Pack 1?
There are two workarounds:

Delete one record from table ServerUpgradeHistory


USE [name_of_you_SSRS_database]
DELETE FROM ServerUpgradeHistory WHERE ServerVersion = 163


Install Cumulative Update 1 for SQL Server 2014 Service Pack 1. Before updating your SQL Server 2014 SP1 with Cumulative Update 1 - test it hard in your lab.

BE AWARE - Pay attention to backup encryption keys before you upgrade SSRS 2012 to
2014. After you apply CU1 all your encrypted content will be inaccessible.