This article discusses the following:
- Lists the SQL Server Desktop Engine (also known as MSDE
2000) system requirements.
- Describes where you obtain MSDE 2000.
- Gives you licensing information for MSDE 2000.
- Explains how to install MSDE 2000.
System Requirements for MSDE 2000
MSDE 2000 is a royalty-free, redistributable database engine that
is fully compatible with Microsoft SQL Server 2000. Here are the system
requirements for MSDE 2000:Operating Systems
MSDE 2000 is designed to run on the following operating
systems, as an embedded database for custom applications that require a local
- Microsoft Windows 98
- Microsoft Windows Millennium Edition
- Microsoft Windows NT Workstation 4.0 with Service Pack 5
(SP5), or later
- Microsoft Windows NT Server 4.0 with Service Pack 5 (SP5),
- Microsoft Windows NT version 4.0 Server Enterprise Edition
with Service Pack 5 (SP5), or later
- Microsoft Windows 2000 Professional
- Microsoft Windows 2000 Server
- Microsoft Windows 2000 Advanced Server
- Microsoft Windows 2000 Datacenter Server
- Microsoft Windows XP
- Microsoft Windows Server 2003
- A computer with a Pentium processor that must be running a
minimum of 166 MHz.
- A minimum of 32 megabytes (MB) of RAM.
NOTE: Microsoft recommends that you use 64 MB, or more. Additional
memory may be required, depending on the operating system
- 44 MB minimum of free hard disk space.
- Microsoft Internet Explorer version 5.0, or
NOTE: You must install Microsoft Windows NT 4.0 Service Pack 5, or
later, before you install Microsoft Internet Explorer version 5.0.
How to Obtain MSDE 2000
MSDE 2000 is compatible with other editions of Microsoft SQL
Server 2000 and is available through various Microsoft products beyond SQL
Server 2000 Enterprise, Standard and Developer Editions. MSDE 2000 is
distributed on the CD with all editions of Microsoft Office that include
Microsoft Access 2002, such as Microsoft Office XP Professional, Microsoft
Office XP Developer, and Microsoft Office XP Premium. MSDE 2000 is located on
the Office CD-ROM in the MSDE 2000 folder. It is also available to registered
users of Microsoft Visual Studio .NET Architect, Developer, and Professional
Editions. Registered users of Visual Studio can obtain the latest version of
MSDE by contacting the Microsoft Order Desk at
For additional information, click the following article number to view the
article in the Microsoft Knowledge Base:
Replacing damaged or defective Visual Studio product disks
Additionally, you can obtain Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) Release A from Microsoft Download
Center. To download Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A, visit the following Microsoft Web site:
MSDE 2000 Licensing
Redistribution rights and licensing guidelines for MSDE 2000 are
handled differently according to the application with which it is included. For
licensing information and the appropriate uses of MSDE 2000, visit the
following Microsoft Web site:
How to Install MSDE 2000
MSDE 2000 features a Windows Installer-based installation and is
distributed as a set of 25 merge modules. There are two ways to install MSDE
- As a stand-alone installation by using the Windows
Installer package that is included with the SQL Server Setup
- By embedding the MSDE 2000 Setup into any custom setup file
by consuming the MSDE 2000 merge modules.
More information about each one of these methods follows.
Stand-Alone MSDE 2000 Installation
A Setup.exe install launcher is a boot-strapper of the
Windows Installer engine, Msiexec.exe. This boot-strapper comes with a
supporting Sqlrun.cab file, and all Windows Installer packages. This Setup.exe
installation launcher, which wraps all 16 Windows Installer packages,
incorporates the ability to detect installed instances and automatically select
from the suite of 16 packages to install new instances of SQL Server.
If you install MSDE 2000 by using the Setup.exe file, you can turn on verbose
logging option for troubleshooting purposes. For example, you can supply a L*v
command-line parameter and provide a file name for
logging purposes. For example: D:\MSDE2000\>setup.exe
/settings D:\MSDE2000\setup.ini /L*v C:\MSDE_setup.log
In the example, a Setup.ini file is specified that contains the settings for
TARGETDIR, DATADIR, INSTANCENAME, and COLLATION. If you specify the /settings
option, you must set the options in the .ini file, not in the
command prompt switches. Copy the .ini file to the same folder as the Setup.exe
For more information about using the Setup.exe file and the
various command-line switches, see the "SQL Server 2000 Desktop Engine Setup"
topic in SQL Server Books Online.Embedded MSDE Adaptation
You can consider consuming MSDE 2000 merge modules into your
custom application setup. This "Embedded MSDE Adaptation" installation fuses
the custom application and MSDE 2000 components into a single product, under a
single product code, and permits simultaneous installation of both parts, and
the whole implementation is Windows Installer based.
For additional information, click the following article
number to view the article in the Microsoft Knowledge Base:
Embedding MSDE 2000 Setup into the setup of custom applications (White paper)
For additional information, click the following article
numbers to view the articles in the Microsoft Knowledge Base:
PRB: Cannot specify instance name using SQL Server 2000 merge modules
How to author MSDE 2000 setup packages with Microsoft Visual Studio Installer 1.1
For more information about MSDE 2000 features and
capabilities, visit the following Microsoft Web sites: