Method for changing the account used by the Active Directory Import Utility to query AD

book

Article ID: 224223

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

Is there a method for changing the account used by the Active Directory Import Utility to query Active Directory (AD), or does the AD Connector configuration need to be removed and replaced via the Active Directory Connector Utility (ADConnectorSetup.exe)?

Environment

Release : 6.5.4

Component : Active Directory Import Utility

Resolution

To edit the account used by the importer to query Active Directory, follow this procedure:

  1. Using SQL Server Management Studio, connect to the database engine hosting the ActiveDirectoryDW data warehouse
  2. In Object Explorer, navigate to Databases > ActiveDirectoryDW > Tables
  3. Right-click the table dbo.Server and select Select Top 1000 Rows
  4. Note the ServerID of the AD server to be updated
  5. From the File menu, select New > Query with Current Connection
  6. In the new query editor window, copy, paste, and edit the following script:
    USE ActiveDirectoryDW;
    GO
    UPDATE [Server]
    SET Username = '<username>' --Provide the new username in the format 'domain\username'
    WHERE ServerID = <ID> --Provide the ServerID value from step 4
    ;
  7. Run the script by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu
  8. In Object Explorer, navigate to Security > Credentials
  9. Right-click Bay Dynamics AD Connector Credential and select Properties
  10. In the Credential Properties window, enter the new account identity and password to be used to query AD
  11. Click the OK button
  12. From a command prompt, navigate to the folder in which the Active Directory importer is installed and run the following command after editing it to use the ServerID from step 4 and the password entered on step 10:
    ImportADUsersAndComputers.exe -setapipassword [ServerID to update] [password for the AD server]