585 pts.
 SQL Server 2005 Reporting Services Move
I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?

Software/Hardware used:
sql server 2005, windows 2003
ASKED: February 10, 2011  9:12 PM
UPDATED: February 11, 2011  7:13 PM

Answer Wiki:
You have to install a new SQL Report server, and configure it. You then need to upload the reports to the SSRS server. You can't just restore the database as the guids for the web servers won't match.
Last Wiki Answer Submitted:  February 11, 2011  7:13 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _