Cube processing fails with Errors in the high-level relational engine. A connection could not be made to the datasource

book

Article ID: 161458

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

Cube processing fails.

Errors in the high-level relational engine

IT Analytics's connection could not be made to the datasource with the DatasourceID of 'ITAnalytics'

 

Cause

Invalid credentials set for impersonation in the datasource.

Resolution

In management studio open a connection to the Analysis service.

-Expand the IT Analytics database

-Expand the Data sources folder you should see the ITAnalytics datasource, right click and choose properties.

-Under Security settings select the Impersonation info and edit

-By default this is set to Inherit change this to a service account or windows account.

The account specified needs access to run queries against the Symantec_CMDB.

 


Applies To

7.5 SMP

SQL 2008 R2

ITA 7.5

ITA Report packs: Any