Cisco Unified MeetingPlace, Release 7.0 -- How to Change and Apply a New SQL Password to Cisco Unified MeetingPlace Web Conferencing

From DocWiki

Jump to: navigation, search

Main page: Cisco Unified MeetingPlace, Release 7.0

Up one level: Configuration



Complete the following tasks in the order shown to change the SQL password and apply the new password to Cisco Unified MeetingPlace Web Conferencing:


Contents

Changing the SQL Password If You Know the Old Password

Before You Begin

If you do not know the old password, proceed to Changing the SQL Password if You Do Not Know the Old Password.


Procedure
  1. Stop the Cisco Unified MeetingPlace Web Conferencing service.
    Caution! Changing the SQL Server account password while the Cisco Unified MeetingPlace Web Conferencing service is running will result in an immediate outage. Stop the service before continuing with the password change procedure.
  2. Open Enterprise Manager.
  3. Expand the Security folder.
  4. Select Logins.
    A list of accounts displays on the right.
  5. Double-click the SQL account that you want to change.
  6. Change the password in the configuration window.


Related Topics


What to Do Next

Proceed to Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing.



Changing the SQL Password if You Do Not Know the Old Password

Before You Begin

If you do know the old password, complete Changing the SQL Password If You Know the Old Password instead.


Procedure
  1. Stop the Cisco Unified MeetingPlace Web Conferencing service.
    Caution! Changing the SQL Server account password while the Cisco Unified MeetingPlace Web Conferencing service is running will result in an immediate outage. Stop the service before continuing with the password change procedure.
  2. Open a DOS command window.
  3. Log in to SQL Server by entering C:\osql -E <nt_acct>, where <nt_acct> is the NT account that has access right to the server.
  4. Change the password by entering sp_password null, <new_pwd>, sa, where null represents the password that you do not know and <new_pwd> is the new SQL password.
  5. Enter go.


Example: Changing the SQL Password by Using osql

This example shows the osql commands executed to log in to osql by using the NT account mpadmin and to change the SQL account SA password from some unknown value to new_pwd.

C:\>osql -E mpadmin

1> sp_password null, new_pwd, sa

2> go

Password changed

1> exit


Related Topics


What to Do Next

Proceed to Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing.




Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing

Before You Begin
  • Ensure that the username and password information that you will provide exists on the SQL Server and that the proper database access rights are assigned.
See the Creating a Least-Privileged SQL Account for Web Conferencing for more information.


  • Verify that all web conferencing services are stopped, including IIS Admin and WWW Publishing services.

Caution! You cannot create or change the username or password on the SQL Server in the Web Conferencing tab. This tab supplies Cisco Unified MeetingPlace Web Conferencing with only the proper SQL database login information.



Procedure
  1. Open the Cisco Unified MeetingPlace Gateway Configurations utility.
  2. Click the Web Conferencing tab.
  3. Change the old SQL password to the new SQL password.
  4. Click Apply.
  5. Click OK.
  6. Restart the Cisco Unified MeetingPlace Web Conferencing service.

NOTE: When you restart the Web Server, all manual changes made to the registry are lost.


Related Topics

Rating: 0.0/5 (0 votes cast)

Personal tools