search cancel

Cube processing job failure due to invalid linked server credentials


Article ID: 213957


Updated On:


IT Analytics


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


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


Release : 2.9.x

Component : Content Pack


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