Trying to connect to the SQL Server Reporting Services reports server for the first time using http://MyServerName/Reportserver, we got 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. SQL Server does not exist or access denied.
Using http://localhost/Reportserver opened a login dialog, but the administrator username and password didn't work.
Discussing this with the company who supplied the server, it came to light that the server name had been changed after SQL Server Reporting Services had been installed.
We resolved this by using the rsconfig utility:
Opening a Command Prompt and executing a line like this:
rsconfig -c -sMyServerName -dReportServer -aWindows -uDomain\Account -pMyPassword
Followed by resetting IIS (Internet Information Services)
iisreset
We hope this helps!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment