Updating the Active Directory server name used by the AD connector utility

book

Article ID: 173531

calendar_today

Updated On:

Products

Information Centric Analytics Data Loss Prevention Core Package

Issue/Introduction

Under some circumstances, it's necessary to update the server name used by the AD connector utility. For example, the Information Centric Analytics (ICA) AD connector logs show ICA is pulling AD data from a domain controller that is no longer in use; or you plan to migrate your AD domain controller to a new server.

Resolution

Update the entry using SQL Server Management Studio (SSMS) by following this procedure:

  1. Using SSMS, connect to the database engine hosting the ActiveDirectoryDW database
  2. Create a backup of the Sever table:

    SELECT *
    INTO [NAME YOUR BACKUP]
    FROM [SERVER]
    ;

     
  3. Update the Server table:

    UPDATE [SERVER]
    SET ServerName = '[correct FQDN of DC]
    WHERE ServerID = [ID of Incorrect DC entry]
    ;