search cancel

Connection errors when viewing reports

book

Article ID: 161593

calendar_today

Updated On:

Products

IT Analytics IT Management Suite Server Management Suite Client Management Suite

Issue/Introduction

When attempting to view IT Analytics reports, the following errors are displayed:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CMDB'. (rsErrorOpeningConnection)
The ConnectionString property has not been initialized.

Cause

A reference to the IT Analytics database is missing in the site's connection string.

Resolution

Add the following to the report server console's connection string:

Data Source=SQLSERVERNAME;Initial Catalog="Symantec_CMDB" 
Data Source=SQLSERVERNAME;Initial Catalog="IT ANALYTICS"