Home / server / Questions / 816053
Accepted
Henrik H
Asked: 2016-11-22 01:01:13 +0800 CST

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

  • 772

After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report:

Exception type: InvalidReportServerDatabaseException

Exception message: 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 '164'. The expected version is '163'.

ssrs sql-server-2012 ssrs-2012

2 Answers

  1. Based on the version that you got which is 163, try to apply this query on the

    instance hosting your reporter server database.

    In my below example, the database is named ReportServer :

    USE [ReportServer]

    DELETE FROM ServerUpgradeHistory WHERE ServerVersion > 163

    • 1
  2. Best Answer

    This can be fixed by applying the same hotfix to the SSRS-server.

    • 0