SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Issue in migrating reporting services 2005 to sql server 2008 R2


Issue in migrating reporting services 2005 to sql server 2008 R2

Author
Message
gary1
gary1
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4950 Visits: 2254
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
gary1
gary1
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4950 Visits: 2254
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
gary1
gary1
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4950 Visits: 2254
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
Debbi Porter
Debbi Porter
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 132
Were you able to upgrade your reports successfully from SQL Server 2005 SP2 to SQL Server 2008 R2?



Gazareth
Gazareth
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7818 Visits: 6046
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!
Debbi Porter
Debbi Porter
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 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!



aozm
aozm
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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!
Debbi Porter
Debbi Porter
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 132
I used a utility, RSScripter, but ended up doing permissions manually as it was actually quicker in our case. Wish you luck!



aozm
aozm
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 6
Thanks! I've seen a few mentions of RSScripter - I will look into it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search