How to Change the (admin) password on an MS SQL Endpoint, in the Identity Manager UI or the Provisioning Manager.
book
Article ID: 40874
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity GovernanceCA Identity Portal
Issue/Introduction
This Document will assist you in changing the admin's password for MS SQL, within the CA Identity Manager UI or in the Provisioning Manager.
Environment
Release: CAIDMB99000-12.6-Identity Manager-B to B Component:
Resolution
For this example I will be using the 'sa' account.
Using the IM UI:
Login to the MS SQL endpoint natively, as the admin account you would like to make the change to (sa).
Once logged into MS SQL, change the password for the specific account. (sa).
Log into the IM UI and change the admin password for that specific SQL endpoint.You will receive a 'Task Completed' message.
Using the Provisioning Manager:
Login to the MS SQL endpoint natively, as the admin account you would like to make the change to (sa).
Once logged into MS SQL, change the password for the specific account. (sa).
Log into the Provisioning Manager, search for the specific SQL endpoint you made the change to, right click -> Custom -> Change Admin Password, and Enter the newly create password for the specific account. (sa).