Processing Errors with Processing ActiveDirectoryDW Steps
Article ID: 184749
Updated On:
Products
Information Centric Analytics
Data Loss Prevention Core Package
Issue/Introduction
While obeserving the steps for processing the Risk Fabric Cube, the step for processing the ActiveDirectoryDW database failed.
Login Failed for user 'xxxxxx\xxxxxxxx'. Reason: Failed to open the explicitly specified database 'ActiveDirectoryDW'. [CLIENT:<local machine>]
Cause
SQL Account 'xxxxxx\xxxxxxxx' did not have SYSADMIN privileges to process the required step
Environment
ICA 6.5.2.1
Resolution
Granted SQL Account 'xxxxxx\xxxxxxxx' SYSADMIN privileges to process the required step. This is going to be consistent for all related ICA databases.
Feedback
Yes
No
Powered by
