Error "Error Saving Reporting Server:The report server cannot open a connection to the report server database." occurs when trying to verify the Report Server Virtual Directory URL in the IT Analytics Configuration

book

Article ID: 157859

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When clicking on the "Verify Connection" button in the IT Analytics Configuration for the Report Server Virtual Directory URL, the error "Error Saving Reporting Server:The report server cannot open a connection to the report server database." occurs.

Error Saving Reporting Server:The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

Cause

The SQL Server Reporting database does not exist or its settings are incorrect.

Resolution

  1. On the SQL Server that manages the SSRS, click on the Windows Start button > All Programs > Microsoft SQL Server 2008 R2 > Configuration  Tools > Reporting Services Configuration Manager.
  2. Click on the Connect button, after making any necessary changes to the login settings if necessary.
  3. Click on Database.
  4. Under Current Report Server Database, if the values are blank or incorrect, click on the Change Database button. Then, follow the instructions to create or edit the database values.
  5. Click on the Exit button.


Related Article

Error "Error Saving Reporting Server: Virtual Directory specified is incorrect." occurs when trying to verify the Report Server Virtual Directory URL in the IT Analytics Configuration
http://www.symantec.com/business/support/index?page=content&id=TECH175259