How to Change the (admin) password on an MS SQL Endpoint, in the Identity Manager UI or the Provisioning Manager.

Products

• CA Identity Manager
• CA Identity Governance
• CA 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:

1. Login to the MS SQL endpoint natively, as the admin account you would like to make the change to (sa).
2. Once logged into MS SQL, change the password for the specific account. (sa).
3. 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:

1. Login to the MS SQL endpoint natively, as the admin account you would like to make the change to (sa).
2. Once logged into MS SQL, change the password for the specific account. (sa).
3. 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).