Solved

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

Posted on 2013-10-30
6
5,596 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this article I will describe the Detach & Attach 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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 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

22 Experts available now in Live!

Get 1:1 Help Now