Sql-server – Reporting Service 2014 Service Pack 1 Failing to work with error – wrong database version

sql serversql server 2014ssrsupgrade

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?

Best Answer

There are two workarounds:

  1. Delete one record from table ServerUpgradeHistory

USE [name_of_you_SSRS_database]

DELETE FROM ServerUpgradeHistory WHERE ServerVersion = 163

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

Related Question