search cancel

Cube processing job failure due to invalid linked server credentials

book

Article ID: 213957

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

Cube processing jobs fail. No additional details are provided in the SQL Server Agent job history.

Cause

The password for the service account used to connect to DLP or SEP data sources during cube processing has been changed.

Environment

Release : 2.9.x

Component : Content Pack

Resolution

To update the password of the account used to query DLP or SEP data sources during cube processing, follow this procedure:

  1. Using SQL Server Management Studio (SSMS), connect to the database engine hosting the ITAnalytics database
  2. In Object Explorer, navigate to Server Objects > Linked Servers
  3. Right-click the linked server for the data source in question and select Properties
  4. In the Linked Server Properties window, select the Security page
  5. Update the password for the Be made using this security context connection login option
  6. Click the OK button