August 17, 2008 at 11:38 pm
I need to migrate SQL Server 2005 Reporting Service from production to DR server. In production server I've about 20 users listed. I took the backup of ReportingService and ReportingServiceTemp database and also backup of encription key and restore it onto the DR server. I followed all thes steps in this kb http://support.microsoft.com/kb/842425/en-us but everything was fine except the reporting users, report permission and dataset. When I go to http:\\localhost\reports under "properties" tab. There are no users exist except Administrator and also all the dataset connection string are missing as well.
I've already tried restoring both Reporting databases almost 3 times without any luck. All the users, permission and datasource connection string are there in the tables. Just users names does't appear at all but the datasource connection name are there but without any connection string.
Any idea what I am doing wrong? Any suggestion will be greatly appriciated. I am just stuck and I don't know how to resolve this issue.
August 18, 2008 at 12:28 am
Hello,
Did the User Logins exist on the DR Server before you restored the ReportServer DB (from the Production Server)? If you look at the ReportServer DB's Users (on the DR Server) do they map as you would expect to the Server Logins?
If not then take a look at this KB article on permission issues that can arise when moving a DB to another Server: http://support.microsoft.com/kb/168001/
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply