Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue in migrating reporting services 2005 to sql server 2008 R2 Expand / Collapse
Author
Message
Posted Tuesday, December 13, 2011 11:45 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 6:42 PM
Points: 667, Visits: 2,055
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
Post #1221104
Posted Wednesday, December 14, 2011 11:08 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 6:42 PM
Points: 667, Visits: 2,055
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
Post #1221888
Posted Thursday, December 15, 2011 11:24 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 6:42 PM
Points: 667, Visits: 2,055
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

Post #1222654
Posted Thursday, January 26, 2012 9:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:19 AM
Points: 22, Visits: 132
Were you able to upgrade your reports successfully from SQL Server 2005 SP2 to SQL Server 2008 R2?


Post #1242273
Posted Thursday, January 26, 2012 10:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:11 AM
Points: 1,872, Visits: 2,995
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!
Post #1242323
Posted Thursday, January 26, 2012 10:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:19 AM
Points: 22, Visits: 132
The reports and subscriptions just completed! I've got a little work to do as we are changing domains too so wish me luck!


Post #1242339
Posted Thursday, January 24, 2013 9:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 24, 2013 12:27 PM
Points: 3, Visits: 6
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!
Post #1411232
Posted Thursday, January 24, 2013 10:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:19 AM
Points: 22, Visits: 132
I used a utility, RSScripter, but ended up doing permissions manually as it was actually quicker in our case. Wish you luck!


Post #1411245
Posted Thursday, January 24, 2013 11:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 24, 2013 12:27 PM
Points: 3, Visits: 6
Thanks! I've seen a few mentions of RSScripter - I will look into it.
Post #1411268
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse