Change the account used by the AD import utility

Products

Information Centric Analytics

Issue/Introduction

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

Environment

Release : 6.x

Component : Active Directory Connector Utility

Resolution

To change the account used by the Active Directory Connector Utility to query Active Directory, follow this procedure:

Open SQL Server Management Studio
Connect to the Database Engine hosting the ActiveDirectoryDW relational database
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
Copy the following query and paste it in the new query editor window:
```
SELECT ServerID, ServerName FROM [ActiveDirectoryDW].[dbo].[Server];
```
Note the ServerID of the server to be updated

Copy the following query and paste it in the new query editor window:

UPDATE [ActiveDirectoryDW].[dbo].[Server]
SET    Username = N'<Username>'
WHERE  ServerID = <ServerID>;

Edit the statement by providing the new username in the format 'domain\accountname' and the ServerID identified by the query 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
The Credential Properties window opens
In the Credential Properties window, enter the new account identity and password to be used to query the domain controller
Click the OK button to close the Credential Properties window

To set or update the password for the account used by the importer, follow this procedure:

On the server hosting the SQL Server service and the Active Directory Connector Utility, open a command prompt (cmd.exe) as an administrator
Navigate to the folder containing the ImportADUsersAndComputers.exe executable. The default path is:
```
%SystemDrive%\Program Files\Bay Dynamics\Active Directory Connector Utility
```
Run the following command to set and encrypt the service account password:
```
ImportADUsersAndComputers.exe -setapipassword <ServerID> <Password>
```
NOTE: If the account password contains special characters, enclose the password in quotation marks (i.e., ")
Run the following command to test the new server configuration and query the domain controller:
```
ImportADUsersAndComputers.exe
```