Upgrading reporting service databases to sql 2005

Last Post 23 Sep 2008 11:59 AM by trans53. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
trans53
New Member
New Member

--
23 Sep 2008 06:41 AM
Hi all,

I need your help with upgrading reporting services since i am not familiar with this at all.

Currectly we have reproting services 2005 (1399) intalled on the separate server connecting to Reporting databases on another server(sql server 2000 sp4). The report server databases are called RSConfig and RSConfigTempDB. Are those the correct database names for reporting services? I was thinking that at some point the names has been modified since from what i read it should be called
ReportServer and ReportServerTempDB.

The question is what are the correct stepts to upgrade those databases to 2005 and what else needs to be done? Should i change connections strings to point to the new db server and how?
Should i also modify data sources for each report to point to the new db server?

Thanks
trans53
New Member
New Member

--
23 Sep 2008 11:59 AM
Thanks so much, i will try this today


Acceptable Use Policy
---