Password Synchronization is only available for real-time sync.
This article explains how to configure Quick Connect and Active Roles Synchronization Service to allow for real-time password synchronization between AD (Active Directory) and Microsoft SQL accounts.
WORKAROUND
Create a Microsoft SQL connection and configure the following:
Click Configure Query and enter the following:
SELECT sid as Id,name as login from sys.server_principals
Example:
Click Password tab and enable Synchronize and manage passwords and then Configure Query
Enter the following query:
EXEC sp_password null, @newPassword, @login
Configure a Mapping rule accordingly, such as samAccountname to loginID
Configure a Password Synchronization rule for the AD to SQL connections
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center