Today we go through a simple procedure to recover a password on a Cisco Unity Connection System. This procedure can be used to change the System Administrator (SA) or Telephone User Interface (TUI) password (by using the correct value for the CredentialType parameter) for any user on the system as long as you have local access to the box and read/write access to SQL.

A stored procedure is used to change the password (either the SA or the TUI PIN). Complete these steps in order to do this:

1. Open up a database viewer.

You can use CUDLE in this case since it ships on every Cisco Unity/Cisco Unity Connection installation. CUDLE is located in the Tools Depot under the Diagnostic Tools section.

2. Get the ObjectID of the user you want to change the password/PIN for.

In this case, go to the vw_User view, find the Administrator and right-click on the ObjectID column in order to select and copy it to the clipboard.

3. Choose View > Stored Procedures.

4. Select the csp_CredentialModify stored procedure and press the Execute button.

A dialog box appears that displays each parameter. You can read about what each parameter does and what the stored procedures do in the data dictionary view on the stored procedure page. You need to check these three parameters:

• Make sure that the CredentialType is 3 (for SA access).

• Check that the strCredentials field is an unencrypted password. (It is encrypted for you by the stored process.)

• Verify the UserOBjectId you copied in step 2.

5. Press Execute in order to finish this procedure.

This procedure was mentioned here. And you can refer to Cisco Technical Tips Conventions for more information on document conventions.

Thank you for writing a comment