Update the name or IP address of a domain controller queried by the Active Directory Connector Utility
search cancel

Update the name or IP address of a domain controller queried by the Active Directory 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 of a domain controller queried by the Active Directory Connector Utility ("AD Importer") bundled with Information Centric Analytics (ICA). For example, the AD importer's logs capture attempts to query a server that is no longer in use, or you plan to migrate your AD domain controller to a new server.

Environment

Version : 6.x

Component : Active Directory Connector Utility

Resolution

Update the record for the domain controller in the ActiveDirectoryDW database by following this procedure:

  1. Open SQL Server Management Studio (SSMS)
  2. Connect to the Database Engine hosting the ActiveDirectoryDW database
  3. Open a new query editor window by pressing CTRL-N, clicking the New Query button in the SQL Editor toolbar, or selecting File > New > Query with Current Connection from the application menu
  4. Copy the following query and paste it into the new query editor window:
    SELECT ServerID, ServerName FROM [ActiveDirectoryDW].[dbo].[Server];
  5. Note the ServerID of the domain controller to be updated
  6. Copy the following statement and paste it into the new query editor window:
    UPDATE [ActiveDirectoryDW].[dbo].[Server]
    SET    ServerName = '<new server name or IP address>'
    WHERE  ServerID = <ServerID>;
  7. Edit the statement by providing the ServerID identified by the query on step 4
  8. Execute the statement by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Query > Execute from the application menu