Issue in migrating reporting services 2005 to sql server 2008 R2

  • Hi,

    I have done the following steps to migrate SQL Server 2005 reporting services to a new SQL Server 2008 R2 reporting services

    1.Backed up reportserver & reportServerTempdb databases in sql server 2005 reporting services

    2.Back up the encryption key in sql server 2005 reporting services

    3.Install a new reporting services instance of SQL Server 2008 R2 and applied SP1

    4.Restored the reportserver & reportServerTempdb databases in sql server 2008 R2 SP1 instance from the backups of step1

    5.Configured the reporting services 2008 R2 using reporting services configuration manager

    6.In reporting services manager, in Database tab, I have selected the option "choose an existing database" called reportserver(which was restored from sql server 2005)

    7.Everything is successful

    Now, when I try to open the url http://servername/reportserver, I'm getting the below error:

    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 'C.0.8.43'. The expected version is '147'. (rsInvalidReportServerDatabase)

    Please advcie

  • Hi,

    I have uninstalled everything and started from the scratch by following the same steps. But still having the same issue? Am I missing any steps?

    I went through the link http://msdn.microsoft.com/en-us/library/bb326494%28v=sql.90%29.aspx

    But there is NO upgrade option in SQL Server 2008 R2 (It is has been removed in R2)

    se the Database Setup page in the Reporting Services Configuration tool upgrade the report server database.

    Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, click Reporting Services Configuration.

    Connect to the report server instance.

    Click Database Setup.

    Click the Upgrade button.

    You only have to upgrade the report server database. The report server temporary database will be upgraded automatically.

    The beow information is from reportserver log files:

    resourceutilities!WindowsService_0!d80!12/14/2011-10:02:13:: i INFO: Reporting Services starting SKU: Standard

    library!WindowsService_0!e34!12/14/2011-10:02:13:: i INFO: Catalog SQL Server Edition = Enterprise

    library!WindowsService_0!e34!12/14/2011-10:02:13:: i INFO: Current DB Version C.0.8.43, Instance Version 147.

    library!WindowsService_0!e34!12/14/2011-10:02:13:: i INFO: Starting upgrade DB version from C.0.8.43 to 147.

    Here, I have backed up the reportserver database from sql 2005 and restored it in sql server 2008 R2?

    What is meant by Current DB Version C.0.8.43?

    What is meant by Instance Version 147? what instance it's refering to?

    Thanks

  • Good news..

    http://choirulamri.org/?p=512

    From the above link, I understand that SQL Server 2005 Reporting services MUST be at SP2 to upgrade to SQL Server 2008 R2.

    Our SQL Server reporting services has SP1 only.

    Thanks

  • Were you able to upgrade your reports successfully from SQL Server 2005 SP2 to SQL Server 2008 R2?

  • I believe in 2008, there's no upgrade option, the RS Configuration wizards auto-detects the RS db version & upgrades it as appropriate.

    Worked for me going 2000 -> 2008.

    Odd that 2005 needed to be at that SP level!

  • The reports and subscriptions just completed! I've got a little work to do as we are changing domains too so wish me luck!

  • I know this is an old thread, but I am having a similar issue that maybe you can help with. I am trying to move a SQL Server 2005 reporting database to SQL Server 2008 R2. I want to keep the old database up - we are going to have both available for a certain time. So, I backed up the 2005 ReportServer and ReportServerTempDB and restored them on 2008. This gave an issue because of, I think, structure changes in the 2008 TempDB. So, I started from scratch, and restored ONLY the ReportServer and not the ReportServerTempDB.

    The site seems to be working - I can access it without getting any errors. But all the permissions did not seem to get copied over. Is there something else I need to copy over from 2005 to get everything the same in 2008 security wise? I'd hate to have to manually set the permissions on each report, as there are tons. Please advise on what steps I need to do to copy a SQL Server 2005 reporting services database to a SQL Server 2008 R2 database. Both are upgraded to the latest SPs if that helps any.

    Thanks!

  • I used a utility, RSScripter, but ended up doing permissions manually as it was actually quicker in our case. Wish you luck!

  • Thanks! I've seen a few mentions of RSScripter - I will look into it.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply