Wednesday, March 7, 2012

Moving report server database from one server to another

I am using reporting services 2000 with SQL server 2000.
The report server is on my machine and report server database is on another sql server.

I need to move report server database from server1 to server2.I have tried the method which i found on net i.e
1-Stop the reporting services
2-detach the report server database from server1 and attach it to server2
3-reconfigure reporting services using RSconfig wherein i specified the new server name , database name and authentication.
4-Start the reporting services
5-Restart IIS

After following all these steps when i browse the report server i get the following error :

"The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help "

Kindly help me on this.

Did you set up a login on Server2 for SSRS?

|||

i have simply moved the report server database to server2 and given the same authentication which was there for the database.

No comments:

Post a Comment