?
Solved

SSRS:  The report server cannot open a connection to the report server database

Posted on 2013-10-30
6
Medium Priority
?
7,876 Views
Last Modified: 2015-12-28
Hello:

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?

Thanks!

TBSupport
0
Comment
Question by:TBSupport
  • 3
  • 2
6 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39612035
" I changed my password. "

Where and what type of login?
0
 
LVL 1

Author Comment

by:TBSupport
ID: 39612523
Hi lcohan!

I was referring to changing my password in Windows Active Directory, in my domain.

Please let me know, if you have any other questions.

TBSupport
0
 
LVL 40

Expert Comment

by:lcohan
ID: 39612652
"But, I stopped and restarted the services in Administrative Tools and in SSRS Configuraiton Manager. "

Is that on the same computer(server) where you changed your password?
And were the SQL Server and SSRS installed on your local computer and they are not working after you changed your AD NT login password?


Can you access SSMS and connect to that SQL Server - Reporting Services?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
LVL 1

Accepted Solution

by:
TBSupport earned 0 total points
ID: 39612786
Below are your questions and their answers:

Is that on the same computer(server) where you changed your password?  Yes.

And were the SQL Server and SSRS installed on your local computer and they are not working after you changed your AD NT login password?  Yes.


Can you access SSMS and connect to that SQL Server - Reporting Services?  No.

Update:  I fixed this by changing the service to Local Service rather than to my domain account.  And, in Configuration Manager, I found that I did not go far enough inn the wizard that is used to change credentials (i.e. conduct password changes).

Once I did those things, SSRS was back up and running!

It is interesting, though, that SSRS lets me use Local System to drive the SSRS service account but an AD account to connect to the databases.  

For my future reference, do you know why that is?

TBSupport
0
 
LVL 1

Author Closing Comment

by:TBSupport
ID: 39626779
I did not receive any solutions.  Mine was the answer.
0
 

Expert Comment

by:joseph Asuquo MCITP,ITIL
ID: 41387246
HELLO
i have the same issue i have tried every solution i have found online yet i still get this error
The report server cannot open a connection to the report server database. The log on failed. (rsReportServerDatabaseLogonFailed) Get Online Help
The user name or password is incorrect. (Exception from HRESULT: 0x8007052E)  when i run the web service url or report manager url from SRSCM 2012
i have tried the following
ran rsconfig did not work
check database priviledges for the account the account can connect with the database
updated the new password for the account on the scom console, srs console and a sql reporting service startupup account.

please any help i would appreciate.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question