Cisco Unified MeetingPlace

Document ID: 50039

Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Determine the SQL Version
Related Information

Introduction

This document describes how to determine the Microsoft SQL Server version installed on the Cisco MeetingPlace Web machine. The term "SQL Server" in this instance, is used to mean either the full SQL Server or SQL Server Desktop Engine (MSDE).

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

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

• Microsoft SQL Server or MSDE

Conventions

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

Determine the SQL Version

Use these instructions to determine the SQL Server version installed on your MeetingPlace Web machine:

1. Open a DOS prompt, and log in to the OSQL utility using this command string:

   C:>osql -U sa
   

   Password:<type_sa_password>

2. When you have successfully logged into the OSQL utility, enter these commands (each line should be followed by a return):

   1> select @@version
   

   2> go
   

   The MSDE version is displayed in the first line of the output, as shown in this example:

   Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
   Dec 17 2002 14:22:05
   Copyright (c) 1988-2003 Microsoft Corporation
   Desktop Engine on Windows NT
   5.0 (Build 2195: Service Pack 3)
   

   Note:  .760 indicates that the SQL Server version is SP3 or SP3a (not to be confused with 5.0 (Build 2195: Service Pack 3), which indicates the level of the Windows 2000 Operating System (OS) service pack).

   This is a complete list of Microsoft SQL Server 2000 data engine versions:

   • SQL Server 2000 RTM 8.00.194 RTM

   • Database Components SP1 8.00.384 SP1

   • Database Components SP2 8.00.534 SP2

   • Database Components SP3 8.00.760 SP3/SP3a

Related Information

• Voice Technology Support
• Voice and IP Communications Product Support
• Recommended Reading: Troubleshooting Cisco IP Telephony
• Technical Support - Cisco Systems