Solved

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

Posted on 2013-10-30
6
6,058 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 39

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 39

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
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

829 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