Connection errors when viewing reports

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.

Environment

ITA 8.x

ITMS 8.x

Cause

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

Resolution

Added the following to the Report Server console's connection string:

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