Processing Errors with Processing ActiveDirectoryDW Steps

book

Article ID: 184749

calendar_today

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.