Solved

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

Posted on 2013-10-30
6
6,541 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 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