Solved

SSRS:  After migrating to another server

Posted on 2014-03-04
2
375 Views
Last Modified: 2014-03-06
Hello:

I migrated SQL Reporting Services 2008 R2 to another 2008 R2 server.  I'm able to open Report Manager successfully but am getting various errors that reference the "old" server's ReportServerTemp database.

Is there a way of updating all objects in the "new" server's ReportServer and ReportServerTemp databases to reference the new databases?

Specifically, I'm getting an "Invalid object name" error on a table in the ReportServerTemp database.  I suspect that somewhere there is still a reference to the old server's databases.

Thanks!

TBSupport
0
Comment
Question by:TBSupport
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
Comment Utility
If you've backed up (or copied) both DBs at the same time it should work.

Are you sure you've gone through all the migration steps, such as setting the RSExecRole role on the databases?

After the databases are attached, verify that the RSExecRole is a database role in the report server database and temporary database. RSExecRole must have select, insert, update, delete, and reference permissions on the report server database tables, and execute permissions on the stored procedures.
Ref Moving the Report Server Databases to Another Computer
0
 
LVL 27

Expert Comment

by:planocz
Comment Utility
Have you tried re-deploying the reports?
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now