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

When I tried to open the Report Manager URL, I got the following error :

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

The report server cannot open a connection to the report server databaseCause:

This problem might occur because of changing the Current Report Server Database Credential.

Solution:

To solve this issue, you should reset the Current Report Server Database Credential by following the mentioned steps below:

  • Open Reporting Services Configuration Manager > Connect to Report Server Instance.

connenttorscm

  • Select Database Tab from Vertical Left Menu > Select Change Credential.

databaserscm

  • Select SQL Server Account and type user name and password then Test Connection and click Next.

testconnectionrscm

crscm

Summeryrscm

progressrscm

  • After click finish go to again to  Reporting Services Configuration Manager Then Report Manager URL and click it.

reportmanagerurl

The Report Manager URL should now been worked properly.reportmanagerworking

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s