Cisco Unified MeetingPlace Release 6.1 -- How to Change the SQL Password and Apply the New Password to Cisco Unified MeetingPlace Web Conferencing

From DocWiki

Revision as of 21:18, 28 March 2011 by MeetingPlace Moderator (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Cisco Unified MeetingPlace Release 6.1 > Web Conferencing > Configuring > Web Conferencing and SQL Server



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

Contents

To Change the SQL Password If You Know the Old Password
  1. Stop the Cisco MeetingPlace Web Conferencing service.
    For instructions, see the Stopping All Cisco Unified MeetingPlace Web Conferencing Services.
    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, expand the Security folder, and choose Logins . A list of accounts displays on the right.
  3. Double-click the SQL account that you want to change.
  4. Change the password in the configuration window.
  5. Continue with the Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing.
To Change the SQL Password if You Do Not Know the Old Password
  1. Stop the Cisco MeetingPlace Web Conferencing service.
    For instructions, see the Stopping All Cisco Unified MeetingPlace Web Conferencing Services.
    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 NT account that has access right to the server.
  4. To change the password, enter 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 .
  6. Continue with the Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing.
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

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. For more information, see Creating and Using a Least-Privileged SQL Account for Web Conferencing.
  • 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 Web Conferencing with only the proper SQL database login information.

To Apply the New SQL Password to Cisco Unified MeetingPlace Web Conferencing
  1. Open the Cisco Unified MeetingPlace Gateway Configurations utility.
    1. Right-click the Cisco Unified MeetingPlace (orange door) icon in the system tray.
    2. Click Properties .
  2. Click the Web Conferencing tab.
  3. Change the old SQL password to the new SQL password that you configured in the To Change the SQL Password If You Know the Old Password.
  4. Click Apply , then click OK .
  5. Restart the Cisco MeetingPlace Web Conferencing service.

Rating: 0.0/5 (0 votes cast)

Personal tools