SSRS: The report server cannot open a connection to the report server database
Posted on 2013-10-30
I'm running SQL Server 2008 R2. I changed my password. But, I stopped and restarted the services in Administrative Tools and in SSRS Configuraiton Manager. Services are running normally.
But, when I try to go to my Report Manager URL, I get the following message in the web page:
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)
Also, when I try to go into Reporting Services in SQL Management Studio, I get messages saying that the URL is not valid.
How do I eliminate these errors so that I can get back into Report Manager and get back into my reports?