Connector Guides › Connectors Guide › Connecting to Endpoints › MS SQL Server Connector › SQL Password Changes

Previous Topic: MSSQL Endpoint with Trusted Connection Fails

Next Topic: Database Users
SQL Password Changes

When trying to make SQL account password changes using the User Console, you must set the "Enforce synchronized account passwords" configuration parameter to No. You can access this parameter from the System, Domain Configuration, Password section of the Provisioning Manager.

Unlock an Account

You can use the CA Identity Manager User Console to unlock an account on a Microsoft SQL Server endpoint.

An account is locked after too many attempts to log in with an incorrect password.

Follow these steps:

  1. Log in to the User Console as an administrator.
  2. Click Users, Modify User's Endpoint Accounts, then search for the user.
  3. Click the Account tab, then find the Status section.

    If the Account is Locked box is checked, this account is locked.

  4. Uncheck the box to unlock the account, then click Submit.