June 17, 2010 at 1:31 pm
I was told to migrate our Reports to the new report server. It is running SQL Server 2008 Standard Edition (64 bit).
The operating system is Windows Server 2008 R2 Enterprise.
I've gone through the steps that I thought I should do.
1. Backup the encryption key
2. Backup the RS databases
3. Transfer the key and database backups to the new 2008 server
4. Turn off Reporting Services on the 2008 server
5. Restore the RS databases on the 2008 server
6. Start the RS configuration tool and turn on Reporting Services
7. Reset the database connection using the configuration tool
8. Restore the RS encryption key
9. run 'select * from ReportServer.dbo.Keys' on new server to see installationid
I got most of the above from http://blogs.egroup-us.com/?p=1600.
=====================================================
Now, I have the url up and running. Report Manager is showing me all my folders.
When I click on the folder, I see all my reports. Great.
I click on a report and I get an error.
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors
Anyone have any insight on some possible troubleshooting steps I could take?
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
July 27, 2010 at 1:27 pm
Try re-entering the passwords on any shared datasources.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply