Cisco Unified MeetingPlace

Document ID: 51045

Contents

Introduction
Before You Begin
      Requirements
      Components Used
      Conventions
Upgrade and Installation Procedures
      Upgrade MSDE to version 2.0 SP3a
      New installation of MSDE 2.0 SP3a
Related Information

Introduction

This document provides steps for upgrading or installing Microsoft Data Engine (MSDE)

Note: Before upgrading MSDE or uninstalling MSDE, you should always backup the Cisco MeetingPlace Web (MPWEB) application's database. Reference the following two Tech Note documents:

• MeetingPlace Web MPWEB SQL Database Backup

• MeetingPlace Web MPWEB SQL Database Restore

Before You Begin

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on the hardware and software versions.

• MSDE 2.0 Service Pack (SP) 3a

Conventions

For more information on document conventions, see the Cisco Technical Tips Conventions.

Upgrade and Installation Procedures

Upgrade MSDE to version 2.0 SP3a

Follow the instructions provided below:

1. Download Microsoft Structured Query Language (SQL) Server Desktop Engine (MSDE) SP3a from:

   http://www.microsoft.com/sql/downloads/2000/sp3.asp

2. The download file for MSDE SP3a is sql2kdesksp3.exe.

   1. After the download, double-click sql2kdesksp3.exe to extract the installation files. The default folder where files are extracted to is c:\sql2ksp3.

   2. Open a DOS command window, and navigate to the c:\sql2ksp3\MSDE folder.

   3. Enter the following command string to install SP3a:

      c:\sql2ksp3\MSDE>setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa_pwd /L*v c:/msdelog.log
      

      Where: sa_pwd = password for the sa account. Do not put password in quotes.

      Note: You may get a pop-up error message: unable to run script files. This does not appear to impact the MSDE upgrade. Click OK to dismiss the pop-up window.

   4. When prompted, restart the server.

New installation of MSDE 2.0 SP3a

Follow the steps below:

1. If the Cisco MeetingPlace Server already has MSDE installed, you must remove it first.

   Use Add/Remove Programs to remove Microsoft SQL Server Desktop Engine.

2. Download MSDE SP3a from:

   http://www.microsoft.com/sql/downloads/2000/sp3.asp

3. The download file for MSDE SP3a is sql2kdesksp3.exe.

   1. After the download, double-click sql2kdesksp3.exe to extract installation files. The default folder where files are extracted to is c:\sql2ksp3.

   2. Open Explorer and navigate to the c:\sql2ksp3\MSDE folder.

   3. Navigate to the sql2ksp3 folder, open setup.ini in Notepad, add the options below, then Close setup.ini.

      [options]
      SAPWD=sa_pwd
      SECURITYMODE=SQL
      TARGETDIR = "d:\Program Files\Microsoft SQL Server\"
      DATADIR = "d:\Program Files\Microsoft SQL Server\"
      

      Note: sa_pwd = password for the sa account. You must assign a password to the sa account. DO NOT put password in quotes.

      Note: If you do not specify TARGETDIR, MSDE will be installed into c:\Program Files\Microsoft SQL Server\ by default (Microsoft appears to add subfolders of \MSSQL\Binn and \MSSQL\Data automatically). If you have more than one partition, it is recommended that you install MSDE onto a drive other than the C: drive. The example above shows MSDE being installed onto the D: drive

4. Double-click setup.exe to install MSDE 2.0 SP3a.

5. When prompted, restart server.

Related Information

• Conferencing Software
• Voice Technology Support
• Recommended Reading: Troubleshooting Cisco IP Telephony
• Technical Support - Cisco Systems