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

The difference between the SQL SA account and the SQLSvc account, and how to change the passwords

Core Issue

The accounts are defined

  • The SQLSvc account functions as the core account that is used for server-to-server interaction within a Cisco CallManager system. This account supports the Cisco Database Layer Monitor service and must be the same on every machine in the cluster for database replication to work properly.

  • The Structured Query Language (SQL) Server Administration (SA) Account serves as the default SQL Server administration account. The SA password is used only during installation and migration. Most of the system does not use this account.

Caution: The SQLSvc password and the SA password can be different, but a password chosen for the SA account must be the same for all the servers in the cluster. The same rule applies for the SQLSvc account password as well.

Resolution

For Cisco CallManager versions 3.3(2)spA and later, complete the steps documented in How to change the password for Cisco CallManager services such as SQLSvc in CallManager 3.3(2) spA and later using AdminUtility.exe

Also, refer to:How to change the administrator password on Cisco CallManager, Cisco Unity, IVR and ICM for more information.For earlier versions of the Cisco CallManager, complete these steps: 

  1. Choose Start > Programs > Administrative Tools > Computer Management.

  2. Click + (the plus sign) next to Local Users and Groups in the left column.

  3. Click Users.

  4. Right-click SQLSvc in the right column and choose Set Password.

  5. Enter the new password and confirm the password.

  6. Click OK to confirm and close the Change Password dialog box.

  7. Click + (the plus sign) next to Services and Applications in the left column.

  8. Click Services.

  9. In the right column, click and highlight Cisco Database Layer Monitor.

  10. Right-click Cisco Database Layer Monitor and choose Properties.

  11. Select the Log On tab.

  12. Change the password and confirm that the password matches the local .\SQLSvc user password set in step five.

  13. Click OK to return to the Services List.

  14. Repeat steps 10 through 13 for the MSSQLServer and SQLServerAgent services.

  15. Close the Computer Management window.

  16. Choose Start > Programs > Administrative Tools > Component Services.

  17. Click + (the plus sign) next to Component Services.

  18. Click + (the plus sign) next to Computers.

  19. Click + (the plus sign) next to My Computer.

  20. Click + (the plus sign) next to COM+ Applications.

  21. Right-click DBL and choose Properties.

  22. Click the Identity tab.

  23. Change the password and confirm that the password matches the SQLSvc user password set in step 5.

  24. Click OK to go back to the Component Manager.

  25. Right-click DBL and click Shut Down.

  26. Right-click DBL and click Start.

  27. Close the Component Manager window.

  28. Repeat steps 1 through 27 for all Subscribers in the Cisco CallManager cluster. The SQLSvc password needs to be identical for all servers in the cluster.

In order to change the SQL SA account password, complete these steps:

  1. Choose Start > Programs, Microsoft SQL Server 7.0 > Enterprise Manager.

  2. Choose Security > Logins in the tree.

  3. Highlight Logins in the left window. All the accounts configured in SQL appear.

  4. Highlight the SA account and click the right button.

  5. Choose Properties in the window that appears.

  6. The password must be on the General tab.

  7. Change the password and either press OK or Apply.

Refer to these documents for more information:

Version history
Revision #:
1 of 1
Last update:
‎06-22-2009 03:39 PM
Updated by:
 
Labels (1)