FREE TEXT QUERY  
  GUIDED SEARCH  
  VIEW ALL SOLUTIONS  

Knowledge Base:
  
 




Feedback
Please rate this solution.
 Excellent
 Good
 Average
 Fair
 Poor
This solution solved my problem.
 Yes
 No
Suggestions for improvement.
(Please include your email address if you would like to hear from us).
 


Search Result
Solution # K20914488
Title The difference between the SQL SA account and the SQLSvc account, and how to change the passwords
Core Issue

The accounts are defined in Cisco CallManager:Administrative Accounts and Passwords:

  • 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 TAC Case Collection Case #K96486351.

Also, refer to TAC Case Collection Case #K54514148 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:

Problem Type
Ask a how to ... question
Call control software (CallManager, CallManager Express, ICS7750, SRST, SS7 call agents)
Call Control CallManager
CallManager Features Installation, upgrade, password recovery, backup, virus, subsystem, licensing, compatibility, support or other CCM issue
Common Software and Product Issues Passwords
How to ... How to ... CallManager configuration, administration, accounts and passwords
CallManager Configuration, Administration, Accounts and Passwords
Windows SQLSvc user
SQL server sa user
Operating System Components SQL
Direct URL http://www.ciscotaccc.com/voice/showcase?case=K20914488