Run Staging Procedures fails querying the ActiveDirectoryDW linked server

Products

• Information Centric Analytics

Issue/Introduction

The RiskFabric Processing job step Run Staging Procedures (4) fails during processing and logs an error similar to the following in the SQL Server Agent log:

LogGroupID=31045;LogID=898127;LogGroupDescription=Staging procedure for AD;ErrorDesc=Error Msg: Could not find server 'RISKFABRIC_AD_RISKFABRIC_<server name>_ACTIVEDIRECTORYDW' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.Line  Number: 1

Environment

Release : 6.x

Cause

The previously created ActiveDirectoryDW linked server was corrupted or deleted.

Resolution

To re-create the ActiveDirectoryDW linked server, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric database
3. In Object Explorer, navigate to Server Objects > Linked Servers
4. Right-click the Linked Servers folder and select New Linked Server...
   
   The New Linked Server window appears
   
   
5. On the General page, enter the name of the linked server as found in the RiskFabric.dbo.LinkedServers table:

   SELECT LinkedServerName FROM RiskFabric.dbo.LinkedServers WHERE LinkedServerType = 'AD';

6. For the Provider, select Microsoft OLE DB Provider for SQL Server
7. For the Data source, enter the host name of the server hosting the ActiveDirectoryDW database
8. On the Security page, select the option for the connection to Be made using the login's current security context
9. Click the OK button to close the New Linked Server window