SQL Server 2005 Reporting Services Move

585 pts.
Tags:
Report Server
Reporting Services 2005
SQL Server 2005
SQL Server migration
SQL Server Report Server
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following