Configuration Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3. - Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and SQL Server [Cisco Unified MeetingPlace]

Table Of Contents

Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and SQL Server

About Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and SQL Server

About Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure

How to Restore the Cisco Unified MeetingPlace Web Server After Boot Failure

Restoring the Cisco Unified MeetingPlace Web Server if the Audio Server Has Changed

Restoring the Cisco Unified MeetingPlace Web Server if the Audio Server Has Not Changed

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

Changing the SQL Password by Using Enterprise Manager

Changing the SQL Password by Using osql

Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing

How to Modify the SQL Database Properties to Manage MPWEB Database Size

Modifying the SQL Database Properties to Manage Database Size

How to Backup and Restore MPWEB SQL Database

Creating a Backup File by Exporting the MPWEB Database

Restoring the Database

How to Detach and Attach the MPWEB SQL Database

Detaching the Database

Attaching the Database

How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database

Preparing the Current Cisco Unified MeetingPlace Web Server

Installing the Replacement Cisco Unified MeetingPlace Web Server

Building the Replacement Cisco Unified MeetingPlace Web Server

How to Access Cisco Unified MeetingPlace Web Conferencing When Locked-Out Due to Incorrect User Authentication Setup

Updating the Cisco Unified MeetingPlace Web Conferencing User Authentication Mode in SQL Server

Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and SQL Server

The procedures in this chapter are restricted to Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and later releases.

Note The SQL commands and operations described in this chapter are provided only for your convenience and should not be treated as definitive reference. For additional details about these commands and operations, search the Microsoft Knowledgebase or download the free Microsoft SQL Server 2000 Online Help package from Microsoft.

Topics in this section include:

• About Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and SQL Server

• About Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure

• How to Restore the Cisco Unified MeetingPlace Web Server After Boot Failure

• How to Change the SQL Password and Apply the New Password to Cisco Unified MeetingPlace Web Conferencing

• How to Modify the SQL Database Properties to Manage MPWEB Database Size

• How to Backup and Restore MPWEB SQL Database

• How to Detach and Attach the MPWEB SQL Database

• How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database

• How to Access Cisco Unified MeetingPlace Web Conferencing When Locked-Out Due to Incorrect User Authentication Setup

Note In this chapter, SQL Server refers to either full SQL Server or Microsoft SQL Desktop Engine (MSDE).

About Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and SQL Server

SQL Server and Cisco Unified MeetingPlace Web Conferencing Release 5.3(235) and later releases are also discussed in the following sections:

Guide

Section

Installation and Upgrade Guide

Chapter 2: About the Cisco Unified MeetingPlace Web Conferencing Release 5.3 Installation

Chapter 2: Creating a Least Privileged SQL Account

Chapter 4: About Installing Cisco Unified MeetingPlace Web Conferencing Release 5.3 in a Load Balancing Configuration for Video-Enabled Systems

Chapter 5: Removing SQL Server or MSDE

Configuration Guide

Chapter 2: Updating SQL Account Access from the MeetingPlace Gateway Configurations Utility, page 2-10

Chapter 8: How to Assess Performance Degradation Due to the Database Scalability Limitation of MSDE, page 8-7

About Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure

The Cisco Unified MeetingPlace Web Conferencing SQL database is created from information that is replicated from the Cisco Unified MeetingPlace Audio Server. The Cisco Unified MeetingPlace Replication Service continues to update this SQL database in real-time as changes occur in the audio server database.

The Cisco Unified MeetingPlace Gateway SIM is a common component of the Cisco Unified MeetingPlace gateway products. Gateway SIM functions as the channel through which gateways communicate with the Cisco Unified MeetingPlace Audio Server. The Gateway SIM allows you to add and delete units from the audio server.

Once a unit (gateway server) is attached to a Cisco Unified MeetingPlace Audio Server, you should only detach it for the following reasons:

•You are replacing an old gateway server with a new server.

In this case, detach the old gateway server from the Cisco Unified MeetingPlace Audio Server to decommission it.

•You are replacing the Cisco Unified MeetingPlace Audio Server with a brand new machine.

–The new audio server uses the same database from the old server.

–The new audio server uses a brand new database.

•You are testing the gateway server in a lab against a lab Cisco Unified MeetingPlace Audio Server.

When the gateway is ready to be put into production, detach it from the lab audio server and re-attach it to a production audio server.

Because the Cisco Unified MeetingPlace Web Conferencing SQL database is based on the Cisco Unified MeetingPlace Audio Server database, a serious database corruption can occur if you switch the audio server and continue to use the old SQL database on the Cisco Unified MeetingPlace web server.

Cisco Unified MeetingPlace Web Conferencing stores the hostname of the Cisco Unified MeetingPlace Audio Server in its SQL database. This hostname is the value you entered when you installed Cisco Unified MeetingPlace Web Conferencing. To prevent SQL database corruption, when the web server boots up, it compares this hostname with the hostname of the audio server that is configured in the Gateway SIM. If they do not match, Cisco Unified MeetingPlace Web Conferencing considers the audio server to have changed and fails to boot up.

To restore the Cisco Unified MeetingPlace web server after boot failure, see the "How to Restore the Cisco Unified MeetingPlace Web Server After Boot Failure" section.

How to Restore the Cisco Unified MeetingPlace Web Server After Boot Failure

This section describes how to restore Cisco Unified MeetingPlace Web Conferencing functionalities after a boot failure due to mismatched audio server hostnames.

Topics in this section include:

• Restoring the Cisco Unified MeetingPlace Web Server if the Audio Server Has Changed

• Restoring the Cisco Unified MeetingPlace Web Server if the Audio Server Has Not Changed

Restoring the Cisco Unified MeetingPlace Web Server if the Audio Server Has Changed

You must drop (delete) the SQL database that Cisco Unified MeetingPlace Web Conferencing is currently using and create a new SQL database from the database on the new Cisco Unified MeetingPlace Audio Server.

Procedure

Step 1 Delete the current MPWEB database by completing the instructions in the "Detaching the Database" section. You do not need to delete the MPWEB-Slave-#### database.

Step 2 Confirm that the physical files associated with the MPWEB database (mpweb.mdf and mpweb.ldf) are deleted from your hard disk.

Step 3 Restart the Cisco Unified MeetingPlace Web Conferencing service or reboot the server.

When Cisco Unified MeetingPlace Web Conferencing services start up, a new MPWEB database is created.

Restoring the Cisco Unified MeetingPlace Web Server if the Audio Server Has Not Changed

If the Cisco Unified MeetingPlace web server cannot be started because you have changed the value of the hostname in the Gateway SIM administrator's user interface, modify the value of the hostname in the SQL database to match the new hostname value in the Gateway SIM.

You can complete this task in two ways:

• Restoring the Cisco Unified MeetingPlace Web Server by Using SQL Enterprise Manager

• Restoring the Cisco Unified MeetingPlace Web Server by Using osql Commands

Restrictions

This procedure is strictly limited to the situation where the database on the Cisco Unified MeetingPlace Audio Server system is the same as the database on the Cisco Unified MeetingPlace web server.

Caution Misuse of this procedure in any other situations will cause database corruption and subsequent Cisco Unified MeetingPlace Web Conferencing functional failures.

Restoring the Cisco Unified MeetingPlace Web Server by Using SQL Enterprise Manager

Procedure

Step 1 Stop the Cisco Unified MeetingPlace Web Conferencing service.

For instructions, see the "Stopping All Cisco Unified MeetingPlace Web Conferencing Services" section on page 2-2.

Step 2 Verify that all Cisco Unified MeetingPlace Web Conferencing services are shutdown, including the IIS Admin Service and WWW Publishing Service.

Step 3 Open Enterprise Manager and navigate to the \Databases folder.

Step 4 Choose and expand the MPWEB database.

Step 5 From the left pane, choose Tables.

Step 6 In the right pane right-click System; then, from the pop-up menu, choose Open Table > Return all rows.

Step 7 Change the value in the HostName column to the desired value.

Step 8 Start the Cisco Unified MeetingPlace Web Conferencing service or reboot the server.

Restoring the Cisco Unified MeetingPlace Web Server by Using osql Commands

Procedure

Step 1 Open a DOS command window.

Step 2 Log in to the SQL Server by entering C:\osql -U userid -P password, replacing userid and password with the appropriate value.

Step 3 To specify that you want to access the MPWEB database, enter use mpweb; then, enter go.

Step 4 To specify the new hostname value, enter update system set hostname = `hostname', where hostname is the audio server configured in the Gateway SIM administrator's user interface; then, enter go.

Step 5 To verify the new value in the SQL database, enter select hostname; then, enter go.

Example

In this example, the following server information is used:

•Cisco Unified MeetingPlace Audio Server hostname stored in the SQL database is an IP address of 172.16.8.40.

•Cisco Unified MeetingPlace Audio Server specified in the Gateway SIM administrator's user interface is 'SanJoseMP.cisco.com'.

•172.16.8.40 is the IP address of SanJoseMP.cisco.com, and the server has not changed.
C:\>osql -U sa -P password
1> use mpweb
2> go
1> update system set hostname = 'SanJoseMP.cisco.com'
2> go
(1 row affected)
1> select hostname from system
2> go
 hostname
 ----------------------------------------------------------------
 SanJoseMP.cisco.com
(1 row affected)
1>exit
How to Change the SQL Password and Apply the New Password to Cisco Unified MeetingPlace Web Conferencing

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

• Changing the SQL Password by Using Enterprise Manager

or

Changing the SQL Password by Using osql

• Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing

Changing the SQL Password by Using Enterprise Manager

The most convenient method for changing the SQL Server account password is to use Enterprise Manager, which is the administrative tool provided by Microsoft SQL Server.

Before You Begin

To use this procedure, you must know the old SQL password. If you do not know the old SQL password, see the "Changing the SQL Password by Using osql" section.

Procedure

Step 1 Open Enterprise Manager, expand the Security folder, and choose Logins.

A list of accounts displays on the right.

Step 2 Double-click the SQL account that you want to change.

Step 3 Change the password in the configuration window.

Step 4 Proceed to the "Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing" section.

Changing the SQL Password by Using osql

Before You Begin

You can use this procedure whether you know the old SQL password or not.

Procedure

Step 1 Open a DOS command window.

Step 2 If you know the old SQL password, log in to SQL Server by entering C:\osql -U userid -P password, replacing userid and password with the appropriate value; then, proceed to Step 3.

or

If you do not know the old SQL password, 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; then, proceed to Step 4.

Step 3 To change the password, enter sp_password sa_pwd, new_pwd, sa, where sa_pwd is the old sql password and new_pwd is the new sql password.

Step 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.

Step 5 Enter go.

Step 6 Proceed to the "Applying the New SQL Password to Cisco Unified MeetingPlace Web Conferencing" section.

Examples: Changing the SQL Password by Using osql

In the following examples, the output is displayed for each command that is used in the "Changing the SQL Password by Using osql" section.

Sample Output for Changing the SQL Password if You Know the Old Password
C:>\osql -U sa -P sa_pwd
>sp_password sa_pwd, new_pwd, sa
>go
Password changed
1> exit
Sample Output for Changing the SQL Password if You Do Not Know the Old Password

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 the "Creating a Least Privileged SQL Account" section in Chapter 2 of the Installation and Upgrade Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3.

•Stop the Cisco Unified MeetingPlace Web Conferencing service.

•Verify that all Cisco Unified MeetingPlace Web Conferencing services are stopped, including IIS Admin and WWW Publishing services.

Restrictions

•You can only specify a new password in the Web Conferencing tab; you cannot specify a different SQL Server or username.

•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

Step 1 Open the Cisco Unified MeetingPlace Gateway Configurations utility.

a. Right-click the Cisco Unified MeetingPlace (orange door) icon in the system tray.

b. Click Properties.

Step 2 Click the Web Conferencing tab.

Step 3 Change the old SQL password to the new SQL password that you configured in the "Changing the SQL Password by Using Enterprise Manager" procedure.

Step 4 Click Apply; then, click OK.

Step 5 Restart the Cisco Unified MeetingPlace Web Conferencing service.

How to Modify the SQL Database Properties to Manage MPWEB Database Size

The MPWEB database that Cisco Unified MeetingPlace Web Conferencing creates is comprised of two files: MPWEB.mdf and MPWEB.ldf. The .mdf file contains the actual data, while the .ldf contains changes (both the content and timing) made to that data.

On a SQL Server that has been actively and properly managed through regular database backup, this .ldf file (also called Transaction Log) remains a reasonable size. However, if SQL database has not been backed up in a while, this transaction log may become very large.

To modify the SQL database properties, complete the following procedures:

• Modifying the SQL Database Properties to Manage Database Size

Modifying the SQL Database Properties to Manage Database Size

To help prevent the file from growing too large, configure the following three important properties for the MPWEB database:

•Recovery = Simple

•Torn Page Detection = On

•Auto Shrink = On

Restrictions

This procedure applies only to the MPWEB database. Do not apply this procedure to the MPWEB-Slave database.

Procedure

Step 1 Open a DOS command window.

Step 2 To log in to SQL Server, enter C:\osql -U userid -P password, replacing userid and password with the appropriate value.

Step 3 To see the current properties of the database, enter sp_helpdb MPWEB; then, enter go.

Step 4 To modify properties, enter alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on; then, enter go.

Step 5 If you are low on disk space because the database file is already large, force an immediate database shrink and remove empty space in the database files by entering dbcc shrinkdatabase ('mpweb', percent). where percent is the amount of free space that you want to allow.

Examples: Modifying the SQL Database Properties to Manage Database Size

In the following examples, the output is displayed for each command that is used in the "Modifying the SQL Database Properties to Manage Database Size" section.

Sample Output for Viewing Current Database Properties

In this example, Recovery Mode is set to FULL and Torn Page Detection and Auto Shrink are not configured on this database.
1> sp_helpdb MPWEB
2> go
name         db_size       owner        dbid    created         status        
compatibility_level
MPWEB    1254.00 MB    sa           5       Oct 16 2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, 
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, 
IsAutoCreateStatistics, IsAutoUpdateStatistics
Sample Output for Modifying Database Properties
1> alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on
2> go
1> sp_helpdb MPWEB
2> go
name         db_size       owner        dbid    created         status        
compatibility_level
MPWEB   1254.00 MB    sa            5       Oct 16 2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, 
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink, 
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
Sample Output for Decreasing File Size

In this example, the size of the files are decreased in the MPWEB database to allow 10 percent free space in the files of MPWEB.
1> dbcc shrinkdatabase ('mpweb', 10)
2> go
DbId   FileId CurrentSize MinimumSize UsedPages   EstimatedPages
 ------ ------ ----------- ----------- ----------- --------------
      5      2        2912        1280        2912           1280
(1 row affected)
DBCC execution completed. If DBCC printed error messages, contact your system 
administrator.
How to Backup and Restore MPWEB SQL Database

To backup and restore MPWEB database, perform the following tasks in the order shown:

• Creating a Backup File by Exporting the MPWEB Database

• Restoring the Database

Creating a Backup File by Exporting the MPWEB Database

Restrictions

This backup file can be restored only on a SQL Server 2000 or MSDE 2000 server with equivalent or later service pack installed.

Procedure

Step 1 To export the MPWEB database to create a backup copy while Cisco Unified MeetingPlace Web Conferencing is running (as part of a daily backup procedure, for example), proceed to Step 2.

or

To export the MPWEB database so that it can be imported on another SQL Server that can continue operations for this Cisco Unified MeetingPlace web server, stop the Cisco Unified MeetingPlace Web Conferencing service and wait for all the while Cisco Unified MeetingPlace Web Conferencing services, IIS Admin service, and World Wide Web publishing service to cease.

Step 2 If the SQL Server that is hosting the MPWEB database runs on the Cisco Unified MeetingPlace web server, proceed to Step 3.

or

If the SQL Server hosting the MPWEB database runs on a separate (remote) Windows server, locate that Windows server and log on.

Note If you cannot log on to that Windows server, log on to any Windows-based workstation or server on the network that has a valid installation of SQL Server Client tools, including the osql command, so that you can connect remotely to the SQL Server.

Step 3 To access the command prompt, choose Start > Run and enter cmd.

Step 4 To connect to SQL Server by using osql with the SA account and the appropriate password, enter osql -U sa -S servername, where servername is the Windows server name.

•If the SQL Server runs locally, you can omit the option -S servername.

•If you are not allowed to connect to this SQL Server as sa, connect by using an account with enough privileges to backup a database.

Step 5 Choose a fully qualified path and filename for your database export.

Note If you are connected to the SQL Server by running osql on a remote workstation or server, this path must be valid on the Windows server that hosts SQL Server, not on your local workstation.

Step 6 To export the database, enter backup database MPWEB to disk = 'fullyqualifiedpath', where fullyqualifiedpath is the location that you chose in Step 5; then, enter go.

Step 7 To confirm that the operation is successful, review the informational messages.

Step 8 To determine the slave database name on your SQL Server, enter select name from sysdatabases where name like 'MPWEB%'; then, enter go.

Step 9 To backup the slave database, enter backup database [MPWEB-Slave-XXXXXXX] to disk = 'C:\temp\mpweb-slave-XXXXXXXX.dat', where XX are the digits of your MPWEB-Slave database and brackets enclose the database name because of the dash in the filename; then, enter go.

Step 10 To exit osql, enter exit.

Step 11 Save the mpweb.dat and MPWEB-Slave-XXXXXXXX in a safe location, on a tape or network drive on another server, for example.

Examples: Exporting the MPWEB Database to Create a Backup File

In the following examples, the output is displayed for each command that is used in the "Creating a Backup File by Exporting the MPWEB Database" section.

Sample Output for Connecting to the SQL Server
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Exporting to the Database
1> backup database MPWEB to disk = 'C:\temp\mpweb.dat'
2> go
Sample Output for Viewing Informational Messages
Processed 616 pages for database 'MPWEB', file 'MPWEBData' on file 1.
Processed 3 pages for database 'MPWEB', file 'MPWEBLog' on file 1.
BACKUP DATABASE successfully processed 619 pages in 1.709 seconds (2.962 MB/sec)
Sample Output for Determining the Slave Database Name

In this example, the name of the slave database is MPWEB-Slave-37102728.
1> select name from sysdatabases where name like 'MPWEB%'
2> go
---------------------------------------------------
name                
[char              ]
--------------------
MPWEB               
MPWEB-Slave-37102728
Sample Output for Backing Up the Slave Database
1> backup database [MPWEB-Slave-37102728] to disk = 'C:\temp\mpweb-slave-37102728.dat'
2> go
Sample Output for Exiting osql
1> exit
C:>
Restoring the Database

Before You Begin

To complete this procedure, you must have a file called mpweb.dat or mpweb-slave-#######.dat that was exported with the backup database command from a SQL Server with a version that is earlier or the same as the SQL Server to which you want to import the database.

Procedure

Step 1 If the SQL Server that hosts the MPWEB database runs on the Cisco Unified MeetingPlace web server, proceed to Step 2.

or

If the SQL Server hosting the MPWEB database runs on a separate (remote) Windows server, locate that Windows server and log on.

Note If you cannot log on to the separate (remote) Windows server, log on to any Windows-based workstation or server on the network that has a valid installation of SQL Server Client tools including the osql command, so you can connect remotely to the SQL Server.

Step 2 Access the command prompt.

Choose Start > Run and enter cmd.

Step 3 Connect to SQL Server by using osql with the SA account and the appropriate password.

Enter osql -U sa -S servername, where servername is the Windows server name.

•If the SQL Server runs locally, you can omit the option -S servername.

•If you are not allowed to connect to this SQL Server as SA, connect by using an account with enough privileges to backup a database.

Step 4 Check if a database called MPWEB exists on this server.

Enter select name from sysdatabases where name like 'MPWEB%'; then, enter go.

Step 5 If a MPWEB database exists, verify that no Cisco Unified MeetingPlace Web Conferencing server is currently using this database.

Step 6 (Optional) If one or multiple Cisco Unified MeetingPlace web servers are using the database, do the following:

a. Log on as an administrator on each server.

b. Stop the Cisco Unified MeetingPlace Web Conferencing service.

c. Wait for all the Cisco Unified MeetingPlace Web Conferencing services, IIS Admin service and World Wide Web publishing service to stop.

d. To drop the database, enter drop database MPWEB; then, enter go.

Step 7 Before you import your MPWEB database to SQL Server, find out which database physical files are associated with this MPWEB database.

Enter restore filelistonly from disk = 'C:\temp\mpweb.dat'; then, enter go.

Step 8 Verify the installation folder of the SQL Server where you want to restore this database and check the physical location of the SQL Server master database.

Enter sp_helpfile master; then, enter go.

Note Unless you have a specific reason to restore your MPWEB database to another disk location, such as for performance and tuning or data recovery, we recommend that you restore the MPWEB database to the default Data folder of this SQL Server installation.

Step 9 Restore your database and relocate the database physical files to the correct location.

Enter restore database MPWEB from disk = 'C:\temp\mpweb.dat' with move 'MPWEBData' to 'D:\MSSQLServer\Data\MPWEB.MDF', move 'MPWEBLog' to 'D:\MSSQLServer\Data\MPWEB.LDF'; then, enter go.

Note You must use the with move clause to successfully restore the database because the database backup file contains physical file locations that are not valid for this SQL Server installation.

Step 10 Ensure that the operation was successful by reviewing the informational messages.

Step 11 To restore the MPWEB-Slave-#### database file, repeat Step 9 and Step 10.

Step 12 To exit osql, enter exit.

Examples: Restoring the Database

In the following examples, the output is displayed for each command that is used in the "Restoring the Database" section.

Sample Output for Connecting to SQL Server
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Checking if the MPWEB Database Exists
1> select name from sysdatabases where name = 'MPWEB'
2> go
name
-----------------------------------------------------
MPWEB
1>
Sample Output for Dropping the Database
1> drop database MPWEB
2> go
Deleting database file 'D:\MSSQLServer\Data\MPWEB.LDF'.
Deleting database file 'D:\MSSQLServer\Data\MPWEB.MDF'.
1>
Sample Output for Checking Associated Files

In this example, the MPWEB database was exported from a MSDE 2000 server. The default 'Data' folder for this server is D:\MSSQLServer\Data, and the MPWEB database was created with one data file (logical name = 'MPWEBData' , physical name = D:\MSSQLServer\Data\MPWEB.mdf) and one log file (logical name = 'MPWEBLog' , physical name = D:\MSSQLServer\Data\MPWEB.ldf).
1> restore filelistonly from disk = 'C:\temp\mpweb.dat'
2> go
---------------------------------------------------
LogicalName PhysicalName            Type  FileGroupName Size          MaxSize              
----------- ------------------------ ------ ------------- -------------- 
---------------------
MPWEBData  D:\MSSQLServer\Data\MPWEB.mdf D     PRIMARY
    2490368.000000 35184372080640.000000
MPWEBLog   D:\MSSQLServer\Data\MPWEB.ldf L     NULL
    1310720.000000 35184372080640.000000
Sample Output for Verifying Folder Installation and Location of SQL Database

In this example, SQL Server (version 2000) was installed in D:\MSSQLServer, and the default 'Data' folder is D:\MSSQLServer\data.
1> sp_helpfile master
2> go
name        filename        filegroup        size              maxsize            growth             
usage
----------------------------------------------------------------------
master
       D:\MSSQLServer\data\master.mdf
       PRIMARY
      15744 KB           Unlimited          10%                data only
1>
Sample Output for Restoring the MPWEB Database by Using the Move Clause

In this example, additional running upgrade step messages are displayed because the database backup file was created by an earlier version of SQL Server.
1> restore database MPWEB from disk = 'C:\temp\mpweb.dat' with move 'MPWEBData' to 
'D:\MSSQLServer\Data\MPWEB.MDF', move 'MPWEBLog' to 'D:\MSSQLServer\Data\MPWEB.LDF'
2> go
Processed 216 pages for database 'MPWEB', file 'MPWEBData' on file 1.
Processed 1 pages for database 'MPWEB', file 'MPWEBLog' on file 1.
Converting database 'MPWEB' from version 515 to the current version 539.
Database 'MPWEB' running the upgrade step from version 515 to version 524.
Database 'MPWEB' running the upgrade step from version 524 to version 525.
Database 'MPWEB' running the upgrade step from version 525 to version 526.
Database 'MPWEB' running the upgrade step from version 526 to version 527.
Database 'MPWEB' running the upgrade step from version 527 to version 528.
Database 'MPWEB' running the upgrade step from version 528 to version 529.
Database 'MPWEB' running the upgrade step from version 529 to version 530.
Database 'MPWEB' running the upgrade step from version 530 to version 531.
Database 'MPWEB' running the upgrade step from version 531 to version 532.
Database 'MPWEB' running the upgrade step from version 532 to version 533.
Database 'MPWEB' running the upgrade step from version 533 to version 534.
Database 'MPWEB' running the upgrade step from version 534 to version 535.
Database 'MPWEB' running the upgrade step from version 535 to version 536.
Database 'MPWEB' running the upgrade step from version 536 to version 537.
Database 'MPWEB' running the upgrade step from version 537 to version 538.
Database 'MPWEB' running the upgrade step from version 538 to version 539.
To achieve optimal performance, update all statistics on the 'MPWEB' database by running 
sp_updatestats.
RESTORE DATABASE successfully processed 217 pages in 0.428 seconds (4.136 MB/sec).
1>
Sample Output for Restoring the MPWEB-Slave Database
1> restore database [MPWEB-Slave-####] from disk = 'C:\temp\mpweb-slave-####.dat' with 
move 'MPWEB-Slave-####Data' to 'D:\MSSQLServer\Data\MPWEB-Slave-####.MDF', move 
'MPWEB-Slave-####Log' to 'D:\MSSQLServer\Data\MPWEB-Slave-####.LDF'
2> go
Sample Output for Exiting osql
1> exit
C:>
How to Detach and Attach the MPWEB SQL Database

To detach and attach the MPWEB SQL database, complete the following tasks in the order shown:

• Detaching the Database

• Attaching the Database

Detaching the Database

Before You Begin

You must detach the MPWEB database with the sp_detach_db command from a SQL Server release that is earlier or equal to the release of the SQL Server to which you want to import the database.

Procedure

Step 1 On the Cisco Unified MeetingPlace web server, log on as administrator.

Step 2 Stop the Cisco Unified MeetingPlace Web Conferencing service and wait for the Cisco Unified MeetingPlace Web Conferencing services, IIS Admin service, and World Wide Web Publishing service to stop.

Step 3 If the SQL Server hosting the MPWEB database runs on the Cisco Unified MeetingPlace web server, proceed to Step 4.

or

If the SQL Server hosting the MPWEB database runs on a separate (remote) Windows server, locate that Windows server and log on.

Note If you cannot log on to the separate (remote) Windows server, log on to any Windows based workstation or server on the network that has a valid installation of SQL Server Client tools, including the osql command, so that you can remotely connect to the SQL Server.

Step 4 Access the command prompt.

Choose Start < Run; then, enter cmd.

Step 5 Connect to SQL Server by using osql with the SA account and the appropriate password.

•If the SQL Server runs locally, you can omit the -S servername option.

•If you are not allowed to connect to this SQL Server as SA, connect by using an account that has enough privileges to backup a database.

Step 6 Access the MPWEB database.

Enter use mpweb; then, enter go.

Step 7 Display a list of the database files.

Enter sp_helpfile; then, enter go.

Step 8 Access the SQL Server master database.

Enter use master; then, enter go.

Step 9 Detach the MPWEB database.

Enter sp_detach_db 'MPWEB; then, enter go.

Step 10 Decide what you should do with the physical files that you identified in Step 7.

These files constitute your detached database. For example, you can archive these files or use them to attach the associated MPWEB database to another SQL Server.

Step 11 Determine the slave database name on your SQL Server.

Enter select name from sysdatabases where name like 'MPWEB%; then, enter go.

Step 12 (Optional) If there is a second database named MPWEB-Slave-####, repeat Step 6 to Step 10 to detach that database, replacing the database name MPWEB with MPWEB-Slave-####.

Note The two databases are logically linked; therefore, if you want to archive the detached MPWEB database, you must do the same for the MPWEB-Slave-#### database. If you want to reattach the MPWEB database to another SQL Server, you must reattach the MPWEB-Slave-#### database, too.

Step 13 To exit osql, enter exit.

Examples: Detaching the Database

In the following examples, the output is displayed for each osql command that is used in the "Detaching the Database" section.

Sample Output for Connecting to SQL Server
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Accessing the MPWEB Database
1> use mpweb
2> go
Sample Output for Displaying a List of Database Files

In this example, the database MPWEB relies on two physical files: C:\MSSQL2K\Data\MPWEB.mdf and C:\MSSQL2K\Data\MPWEB.ldf.
1> sp_helpfile
2> go
name         fileid    filename                   filegroup size   maxsize  growth usage    
------------- ---------- --------------------------- --------- ------- --------- ------- 
---------
MPWEBData             1 C:\MSSQL2K\Data\MPWEB.mdf   PRIMARY  
2432 KB Unlimited 1024 KB data only
MPWEBLog              2 C:\MSSQL2K\Data\MPWEB.ldf   NULL     
1280 KB Unlimited 10%    log only
Sample Output for Accessing the SQL Server Master Database
1> use master
2> go
Sample Output for Detaching the MPWEB Database
1> sp_detach_db 'MPWEB'
2> go
Sample Output for Determining the Slave Database Name

In this example, the name of the slave database is MPWEB-Slave-37102728.
1> select name from sysdatabases where name like 'MPWEB%'
2> go
---------------------------------------------------
name                
[char              ]
--------------------            
MPWEB-Slave-37102728
Sample Output for Exiting osql
1> exit
C:>
Attaching the Database

Before You Begin

Ensure that you have a valid detached MPWEB database, usually, two files named MPWEB.mdf (data file) and MPWEB.ldf (log file), though file names may vary.

Procedure

Step 1 If the SQL Server to which you want to attach your MPWEB database runs on the Cisco Unified MeetingPlace web server, proceed to Step 2.

or

If the SQL Server runs on a separate (remote) Windows server, locate that Windows server and log on. If you cannot log on to that Windows server, log on to any Windows-based workstation or server on the network that has a valid installation of SQL Server Client tools, including the osql command, so that you can remotely connect to the SQL Server.

Step 2 Access the command prompt.

Choose Start > Run; then, enter cmd.

Step 3 Connect to SQL Server by using osql.

Enter osql -U sa -S server-name, where server-name is the Windows SQL Server to which you want to attach the MPWEB database.

Note If the SQL Server runs locally, you can omit the -S server-name option.

Step 4 Enter your password for the appropriate SA account.

Note If you are not allowed to connect to this SQL Server as SA, connect by using an account that has enough privileges to attach a database.

Step 5 Determine if a database named MPWEB already exists on this server.

Enter select name from sysdatabases where name = 'MPWEB'; then, enter go.

Step 6 If no MPWEB database exists, proceed to Step 7.

or

If a MPWEB database exists, ensure that it is not being used by an existing Cisco Unified MeetingPlace web server.

Note You cannot attach a MPWEB database to this SQL Server if an active MPWEB database exists already. Before you proceed, you must detach the existing MPWEB database by completing the "Detaching the Database" procedure.

Step 7 To verify the installation folder of the SQL Server to which you want to restore this database, check the physical location of the SQL Server master database.

Enter sp_helpfile master; then, enter go.

Note Unless you have a reason to restore your MPWEB database to another disk location, such as for performance and tuning or data recovery reasons, we recommend that you restore the database to the default data folder of this SQL Server installation.

Step 8 Copy the MPWEB.mdf and MPWEB.ldf files under the data folder that you identified in Step 7.

Step 9 Attach the MPWEB database.

Enter sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf'; then, enter go.

Step 10 (Optional) 1If you have a valid set of files for the MPWEB-Slave-#### database, repeat Step 5 to Step 10, replacing MPWEB with MPWEB-Slave-#### to attach that database.

Step 11 To exit osql, enter exit.

Examples: Attaching the Database

In the following examples, the output is displayed for each osql command that is used in the "Attaching the Database" section.

The following examples use the files MPWEB.mdf and MPWEB.ldf:

Sample Output for Connecting to SQL Server
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Checking if the MPWEB Database Exists
1> select name from sysdatabases where name = 'MPWEB'
2> go
name
-----------------------------------------------------
(0 row affected)
1>
Sample Output for Checking the Physical Location of the SQL Server Master Database

In this example, SQL Server Version 2000 is installed in C:\MSSQL2K, and the default data folder is C:\MSSQL2K\data.
1> sp_helpfile master
2> go
name filename filegroup size maxsize growth usage
----------------------------------------------------------------------
master
       C:\MSSQL2K\data\master.mdf
       PRIMARY
       15744 KB           Unlimited 10% data only
1>
Sample Output for Attaching the MPWEB Database
1> sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf'
2> go
Sample Output for Exiting osql
1> exit
C:>
How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database

During installation, a MPWEB database is tied to a specific Cisco Unified MeetingPlace web server through a unique GUIDWebID that is generated by the Cisco Unified MeetingPlace Web Conferencing installer and stored in the registry and SQL database. Therefore, if you want to transfer the MPWEB SQL database and all attachments from the old server to a new server, the new server must use the same GUIDWebID as the old server. This requires preparing the following three components from the old server to the new server:

•The whole \MPWEB\Meetings folder (including all sub-folders) in zipped or unzipped format.

•The GUIDS.reg file with modifications to add the GUIDWebID and the mpweb-slave database filename information. The GUIDS.reg file, as well as the GUIDWebID and DBName registry values, come from the old server.

•A backup of the MPWEB database from the old server.

Note You do not need to back up the mpweb-slave database (MPWEB-Slave-#######) because it can be regenerated on the new machine.

To replace an existing Cisco Unified MeetingPlace web server with a new server and retain the attachments of past meetings so that they are accessible from the new server, complete the following tasks in the order shown:

• Preparing the Current Cisco Unified MeetingPlace Web Server

• Installing the Replacement Cisco Unified MeetingPlace Web Server

• Building the Replacement Cisco Unified MeetingPlace Web Server

Preparing the Current Cisco Unified MeetingPlace Web Server

Procedure

Step 1 Stop all Cisco Unified MeetingPlace Web Conferencing services, including the Gateway SIM service.

For instructions, see the "Stopping All Cisco Unified MeetingPlace Web Conferencing Services" section on page 2-2.

Step 2 Detach this Cisco Unified MeetingPlace web server from the Cisco Unified MeetingPlace Audio Server.

a. Open the Gateway SIM Agent.

For instructions, see the "Opening the MeetingPlace Gateway Configurations Utility" section on page 2-6.

b. From the Gateway SIM tab, write down the hostname or IP address of the Cisco Unified MeetingPlace Audio Server for future reference.

Note You must use the same server reference when you install the new Cisco Unified MeetingPlace web server. If the Cisco Unified MeetingPlace Audio Server is specified as a hostname, you will enter that same hostname; if it is specified as an IP address, you will use an IP address later.

c. Detach this Cisco Unified MeetingPlace web server from the Cisco Unified MeetingPlace Audio Server by clicking Delete Unit.

Step 3 Make a copy of the entire \MPWEB\Meetings folder and its contents.

Step 4 Make a copy of the GUIDS.reg file.

You can find this file where Cisco Unified MeetingPlace Web Conferencing application files are stored.

Step 5 Open regedit and obtain the registry values for GUIDWebID and DBName.

Caution Ensure that the registry values are correct. Compare the values that you obtained in Step 5 against what enter in Step 6.

Step 6 Open GUIDS.reg in a text editor and add the GUIDWebID and DBName registry paths and key values.

Step 7 Save the file with these changes.

Step 8 Make a backup of the MPWEB database.

For instructions, see the "How to Backup and Restore MPWEB SQL Database" section section.

Step 9 Copy the attachments, GUIDS.reg and the MPWEB backup to the new server.

Step 10 Proceed to the "Installing the Replacement Cisco Unified MeetingPlace Web Server" section.

Installing the Replacement Cisco Unified MeetingPlace Web Server

Restrictions

You must install the same release of Cisco Unified MeetingPlace Web Conferencing or later on the new server as is running on the old server. For example, if you are running Release 5.3(104.3) on the old server, you must install Release 5.3(104.3) or a later release on the new server.

Before You Begin

Before you install Cisco Unified MeetingPlace Web Conferencing on the new server, you must run GUIDS.reg on the new server to add the following four keys in to the registry: GUID IDs for Site, System, Web, and mpweb-slave db filename. To run GUIDS.reg, right-click GUIDS.reg; then, choose merge.

Procedure

Step 1 Install Cisco Unified MeetingPlace Web Conferencing.

For instructions, see Chapter 2 in the Installation and Upgrade Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3.

Step 2 When you are prompted at the end of the installation, reboot the server.

After the initial reboot, the installation program continues and may reboot a few more times to complete the installation.

Step 3 When you are prompted for the Cisco Unified MeetingPlace Audio Server information, enter the value that you wrote down in Step 2 of the "Preparing the Current Cisco Unified MeetingPlace Web Server" procedure.

Step 4 After the installation completes, verify that Cisco Unified MeetingPlace Web Conferencing is functional.

Step 5 Proceed to the "Building the Replacement Cisco Unified MeetingPlace Web Server" section.

Building the Replacement Cisco Unified MeetingPlace Web Server

Before You Begin

Verify that the release of Cisco Unified MeetingPlace Web Conferencing that is installed on the new server is either the same or later than the release installed on the old server. For example, if you are running Release 5.3(104.3) on the old server, you must be running Release 5.3(104.3) or a later release on the new server.

Procedure

Step 1 Stop all Cisco Unified MeetingPlace Web Conferencing services

Step 2 Delete the MPWEB SQL database that is created automatically during the Cisco Unified MeetingPlace Web Conferencing installation by using either Enterprise Manager or the osql drop database command.

For more information about this osql command, see the "Restoring the Database" section.

Step 3 Restore the old MPWEB database on to the new server by using either Enterprise Manager or the osql restore database command.

For more information about this osql command, see the "Restoring the Database" section.

Step 4 Delete all contents in the \MPWeb\Meetings\ folder.

Step 5 Restore all the files and attachments from the old server in to \MPWeb\Meetings folder.

Step 6 Reboot the server.

or

Restart the Cisco Unified MeetingPlace Web Conferencing service.

Step 7 Access the home page and log in with a System Manager profile to make the appropriate changes in the Web Server administrative pages, such as the web server's Hostname.

How to Access Cisco Unified MeetingPlace Web Conferencing When Locked-Out Due to Incorrect User Authentication Setup

If you configure Cisco Unified MeetingPlace Web Conferencing to use anything other than the MeetingPlace native login form for user authentication, you may not be able to log in to Cisco Unified MeetingPlace through the Web due to incomplete user authentication configuration. For example, you configured LDAP, then MeetingPlace user authentication, but failed to enter a valid LDAP hostname or to ensure that the LDAP user IDs existed in MeetingPlace. In such circumstances, you are unable to log into Cisco Unified MeetingPlace Web Conferencing to correct your configuration errors.

To restore access to Cisco Unified MeetingPlace Web Conferencing, you can do one of the following:

•Create or correct the MeetingPlace profile to allow you to login by using MeetingTime. For more information about MeetingTime, see the Administrator Guide for Cisco Unified MeetingPlace Audio Server Release 5.3.

•Edit the SQL database and reset the mode to MeetingPlace native login form. For instructions, see the "Updating the Cisco Unified MeetingPlace Web Conferencing User Authentication Mode in SQL Server" section.

Updating the Cisco Unified MeetingPlace Web Conferencing User Authentication Mode in SQL Server

Procedure

Step 1 Open a DOS command window.

Step 2 Log in to the SQL server by entering C:\osql -U userid -P password, replacing userid and password with the appropriate value.

Step 3 To specify that you want to access the MPWEB database, enter use mpweb; then, enter go.

Step 4 Enter Update web set AuthMode = 1

Step 5 Enter Update web set AuthLoginMode = 1; then, enter go.

Table A-1 and Table A-2 provide mode definitions as a reference.

Table A-1 AUTHMODE Commands

AUTHMODE Command

Value

#define SQLCONFIG_AUTHMODE_NONE

0

#define SQLCONFIG_AUTHMODE_MP

1

#define SQLCONFIG_AUTHMODE_LDAP

2

#define SQLCONFIG_AUTHMODE_LDAPMP

3

#define SQLCONFIG_AUTHMODE_TRUSTEXT

4

#define SQLCONFIG_AUTHMODE_BASIC_DOMAIN

5

#define SQLCONFIG_AUTHMODE_WIA

6

:

Table A-2 AUTHLOGINMODE Commands

AUTHMODE Command

Value

#define SQLCONFIG_AUTHLOGINMODE_NONE

0

#define SQLCONFIG_AUTHLOGINMODE_WEB

1

#define SQLCONFIG_AUTHLOGINMODE_HTTP

2