Cube processing job failure due to invalid linked server credentials

Products

• IT Analytics

Issue/Introduction

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

Environment

Release : 2.9.x

Component : Content Pack

Cause

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

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