Change AD Importer Password for Domain Controller Connection

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

Active Directory Connector Job Fails with the message: Executed as user: DOMAIN\username. 2018-04-11 19:46:58,595 [1:INFO] LoggingHelper..ctor() configured via code  2018-04-11 19:46:58,672 [1:INFO] Program.Main() Starting run2018-04-11 19:46:59,228 [1:INFO] ActiveDirectoryImporter.Import() Running Active Directory Importer version 1Starting Container Import2018-04-11 19:47:08,970 [1:ERROR] Program.Main() Exception caught in ActiveDirectoryImporter  System.Runtime.InteropServices.COMException (0x8007052E): The user name or password is incorrect.       at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)     at System.DirectoryServices.DirectoryEntry.Bind()     at System.DirectoryServices.DirectoryEntry.get_Name()     at ADConnectorLibrary.ActiveDirectoryImporter.ImportContainers(SqlConnection conn, DirectoryEntry adServer, Int32 serverId)     at ADConnectorLibrary.ActiveDirectoryImporter.Import()     at ImportADUsersAndComputers.Program.Main(String[] args)  2018-04-11 19:47:09,028 [1:ERROR] Program.Main() ActiveDirectoryImporter import was not successful.  Process Exit Code 1.  The step failed.

Executed as user: DOMAIN\username. 2018-04-11 19:46:58,595 [1:INFO] LoggingHelper..ctor() configured via code  2018-04-11 19:46:58,672 [1:INFO] Program.Main() Starting run2018-04-11 19:46:59,228 [1:INFO] ActiveDirectoryImporter.Import() Running Active Directory Importer version 1Starting Container Import2018-04-11 19:47:08,970 [1:ERROR] Program.Main() Exception caught in ActiveDirectoryImporter  System.Runtime.InteropServices.COMException (0x8007052E): The user name or password is incorrect.       at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)     at System.DirectoryServices.DirectoryEntry.Bind()     at System.DirectoryServices.DirectoryEntry.get_Name()     at ADConnectorLibrary.ActiveDirectoryImporter.ImportContainers(SqlConnection conn, DirectoryEntry adServer, Int32 serverId)     at ADConnectorLibrary.ActiveDirectoryImporter.Import()     at ImportADUsersAndComputers.Program.Main(String[] args)  2018-04-11 19:47:09,028 [1:ERROR] Program.Main() ActiveDirectoryImporter import was not successful.  Process Exit Code 1.  The step failed.

Environment

SQL Server, Credential

Cause

The password for the account located in the Server table of the ActiveDirectoryDW has changed but has not been re-encrypted.

Resolution

On the server hosting the AD Import Utility, open a command prompt as an Admin. Change directory to the folder hosting the AD Import Utility Files. Run the following command replacing PASSWORD as appropriate:

ImportADUsersAndComputers.exe -setapipassword 1 PASSWORD

Upon successful completion, you should observe a similar message to this: