1

I just uninstalled SQL Server reporting services native and installed back again from same media which we used 3 years ago. This version is free one (development use only). I configured the report server but am now getting following 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 '163'. The expected version is '162'. (rsInvalidReportServerDatabase)

Here is the current version of SQL Server info.

Microsoft SQL Server 2012 (SP3-GDR) (KB3194721) - 11.0.6248.0 (X64) 
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Please help how to resolve this.

Improve this question
10
  • Have you checked - blogs.msdn.microsoft.com/sql_server_team/…
    – Kin Shah
    Commented Feb 7, 2017 at 19:14
  • 1
    Have you tried applying SP3 to RS? Looks like SQL is running that, but your install probably doesn't have it.
    – Nic
    Commented Feb 7, 2017 at 19:15
  • 1
    Your SSRS is 3 years old, but your SQL server is updated sometimes after last November? Like the error says, the database is newer than SSRS expects
    – James Z
    Commented Feb 7, 2017 at 19:16
  • Was Reporting Services working before you uninstalled it? What was the reason for uninstalling and reinstalling? Are you then pointing it to a ReportServerDB that already exists?
    – seventyeightist
    Commented Feb 7, 2017 at 19:39
  • Hi @seventyeightist, it was but my manager was unable to create another instance of ORG_MSCRM(Dyamics CRM 2015 on-prem.) We were getting following error. "Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Wrong number of tasks found for roleContent Manager, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;"
    – user2040021
    Commented Feb 7, 2017 at 20:31

1 Answer 1

Reset to default
3

Talked through with the Asker in chat but in essence:

Database Engine (SP3) and Reporting Services (RTM) are now installed on the same server but experiencing incompatibility since the "naïve" Reporting Services (installed from a RTM media - overwriting the now-uninstalled updated version) is seeing a more recent (updated) Database Engine ReportServerDB version than it can handle. Database Engine has been upgraded since the original install (via Windows Update or whatever applies to that environment) to SP3 but RS has now been reset to "naïve" RTM version.

Update the installed Reporting Services with SP3 and any CUs to match the installed Database Engine version, restart and re-try. There may be some downtime for users depending on whether it requires a restart so advise/schedule that accordingly.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.