Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Cisco Employee

How to Reset the EIM \ CIM System "sa" Password Procedure

All.

I have posted a document, "How to Reset the EIM \ CIM System "sa" Password Procedure" on this CSC site to assist you w\ the EIM "sa"user password reset procedure.

I am also posting the procedure and word document attachment here.

Let me know how helpful the procedure is.

Bernard

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Resetting The CIM \ EIM System “sa” Password Procedure

Key: ‘ ‘ = Two single quotes.

The following contain the query for blanking out the SA password for Partition 0 thru the backend.

1. Go to SQL Server Management Studio and change the database to master database. USE “eGMasterDB”

2. a. To verify user_name, and select user_id“save the results for backup.
    b. “SELECT user_id, user_name, password, case_insensitive_password FROM egpl_user WHERE user_id = 1”.

Note: Be sure to save query and results, so that it can be provided for troubleshooting, if there is a problem.

3. a. For Blanking out the SA password. UPDATE egpl_user WITH (ROWLOCK) SET password = ‘ ‘, case_insensitive_password = ‘ ‘ WHERE user_id = 1

4. Verify the PW columns are now clear, by re-running the select cmd. “SELECT user_id, user_name, password, case_insensitive_password FROM egpl_user WHERE user_id = 1”.

Then to successfully access and change CIM \ EIM “sa” User Account. (Partition 0)

4. Go to login.  //<EIM server ip address>/system/

5. Login with “sa” as the user name, no password.

6. Navigate to Administration > Partition: System > Users, and highlight sa user under “List: Users”.

7. Highlight the “Password” row, on the “General” tab, under “Properties: sa”.

8. Select the box to the right of row and it will ask if you want to change the password.

9. Select yes, enter new password.

10. Save.

Everyone's tags (1)
1 REPLY
Highlighted
Cisco Employee

Re: How to Reset the EIM \ CIM System "sa" Password Procedure

It's great to have these types of procedures published on CSC!  Thanks, Bernard!

-Paulo

572
Views
0
Helpful
1
Replies
CreatePlease to create content