How to fix Invalid column name 'Version'. (rsRPCError) error in SSRS?


If you installed SQL 2005 reporting service on a system which has SQL 2005 reporting service (SSRS) already installed, you may experience below error when you attempt to open SSRS online portal:

Reporting Services Error
--------------------------------------------------------------------------------

Invalid column name 'Version'. (rsRPCError) Get Online Help

--------------------------------------------------------------------------------

This is actually a known problem in SQL 2005 SP2 or 3 and can be fixed by following below steps:

  1. Go to SQL Reporting Services Configuration. Then go to Database Setup section and Click Script Button. Then select Update DB Script and type in the Report database name (typically ReportServer2005 unless you specifically named it otherwise during installation or configuration) and select Server version (this is the SSRS version where you are giving problem). This will generate a script. Save the script.
  2. Now search for “ReportServerTempdb” and replace that with Report’s temp database name (typically ReportServer2005Tempdb unless you specifically named it otherwise during installation or configuration). Most likely you need to do 2 such replacement. Then finally save the file.
  3. Now run the saved script on SQL 2005 instance where the report server database’s are hosted.

Root cause of this problem is a bug from SSRS.

Comments