ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
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:
Using SQL Server Management Studio, connect to the database engine hosting the ActiveDirectoryDW data warehouse
In Object Explorer, navigate to Databases > ActiveDirectoryDW > Tables
Right-click the table dbo.Server and select Select Top 1000 Rows
Note the ServerID of the AD server to be updated
From the File menu, select New > Query with Current Connection
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 ;
Run the script by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu
In Object Explorer, navigate to Security > Credentials
Right-click Bay Dynamics AD Connector Credential and select Properties
In the Credential Properties window, enter the new account identity and password to be used to query AD
Click the OK button
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]
[If the AD password contains special characters, enclose it in quotation marks (i.e. ")]