The job step Run Staging Procedures (4) of the RiskFabric Processing job fails and logs the following error in both the SQL Server Agent job history and in the RiskFabric table dbo.Log_DataTransformation:
Login Failed for user '[<domain>\]<account>'. Reason: Failed to open the explicitly specified database 'ActiveDirectoryDW'. [CLIENT:<local machine>]
Version : 6.x
Component : RiskFabric Processing
This typically occurs when the SQL Server Agent service account has been changed from NT Service\SQLSERVERAGENT (for the default instance) or NT Service\SQLAgent$<instance-name> (for named instances) to a local or domain user that has not been assigned the sysadmin role in SQL Server and does not have permissions to access the ActiveDirectoryDW database.
Configure the SQL Server Agent to run under the appropriate NT Service account for the SQL Server instance; grant the db_owner privilege on the ActiveDirectoryDW database to the local or domain account under which the SQL Server Agent is running; or grant the sysadmin role to the local or domain account under which the agent is running.