March 11, 2013 at 3:40 pm
Hi all,
Here's the scenario
Production SSRS is on SQL 2005 SP3.
DR SSRS is on SQL 2008
I've got a backup from the Production SSRS and want to use it on the DR box.
When I point the SSRS instance on DR to a restore of the Production backups I get
the version of the report server database is either in a format that is not valid"
The found version is c.0.8.54. The expected version is c.0.9.45 (rsInvalidReportServerDatabase)
Has anyone been able to do what I'm trying successfully ?
I had hoped that the SSRS configuration utility on SQL 2008 would apply the necessary changes to the ReportServer database to bring it from the SQL 2005 schema to the SQL 2008 schema ?
Any help appreciated !
April 5, 2013 at 3:09 pm
When i did my upgrade I had two reoccuring errors. One was the one that you had. Do your reports have background images in the headers? if so try removing them. I know it's strange but that fixed it for me. If that's not the case I'll have to do dome digging to see what the other fix was.
April 5, 2013 at 3:27 pm
Sorry, i totally misread your post. My error was totally different. I read to fast and my mind filled in the blanks.
April 6, 2013 at 3:20 am
No problem Steven.
In the end I just used a different server running the same version of SQL.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply