Solved

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

Posted on 2013-10-30
6
5,719 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A short film showing how OnPage and Connectwise integration works.

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now