Active Directory Connector failure due to incorrect account credentials
searchcancel
Active Directory Connector failure due to incorrect account credentials
book
Article ID: 172061
calendar_today
Updated On: 06-05-2023
Products
Information Centric AnalyticsData Loss Prevention Core Package
Issue/Introduction
The Bay Dynamics AD Connector Job fails and logs the following errors:
[1:ERROR] Program.Main() Exception caught in ActiveDirectoryImporter System.Runtime.InteropServices.COMException (0x8007052E): The user name or password is incorrect.
[1:ERROR] Program.Main() ActiveDirectoryImporter import was not successful. Process Exit Code 1. The step failed.
Environment
Version : 6.x
Component : Active Directory Import Utility
Cause
This failure can be caused by any of the following conditions:
The account name used to query the Active Directory (AD) domain controller is invalid
The password for the account used to query the AD domain controller is invalid (typically expired)
The password for the account used to query the AD domain controller has not been updated correctly and encrypted
Resolution
To update the password used by the Active Directory Import Utility to query AD domain controllers, 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(s) to be updated
In Object Explorer, navigate to SQL Server Agent > Jobs
Right-click the Bay Dynamics AD Connector Job and select Properties The Job Properties - Bay Dynamics AD Connector Job window opens
In the Job Properties - Bay Dynamics AD Connector Job window, select the Steps page
In the Steps page, select the Edit button The Command window opens
In the Command window, note the path to the ImportADUsersAndComputers.exe executable
Open a command prompt as an administrator
Navigate to the path identified in step 9
Edit the following command to use the ServerID from step 4 and the new password for the account:
ImportADUsersAndComputers.exe -setapipassword <ServerID to update> <password for the AD server>
NOTE: If the AD password contains special characters, enclose the password in double quotation marks (i.e., ")