March 6, 2008 at 7:55 am
I have moved DB/Reporting server to new machine, different name and different service a/c , when I run report I get following message
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)
The steps to restore was as follows
1) BACKUP ReportServer and ReportServerTempDB on Source Server
2) Backup key using rskeymgmt on source server
3) stop RS and IIS on destination
4) Restore ReportServer and ReportServerTempDB (backup from step1) on destination
5) Start RS and IIS on destination
6) delete key of Source Server using rskeymgmt -r
7) restore key using RSkeymgmt on destination using Rskeymgmt -a -f -p
8) RSConfig -c -s -d -a -u -p
Could you guys let me know, what i am doing wrong...
March 7, 2008 at 10:49 am
This could be that you did not create devices in the master when you backup and restore reportserverdb and reportservertempdb. And you also need to verify the reporting services is on in configuration manager. The first is how the new relational engine will know the reporting server database you are moving. There is a detailed guide in the link below.
http://technet.microsoft.com/en-us/library/ms156421.aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply