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...