Microsoft KB Archive/324998

= How to obtain and install SQL Server 2000 Desktop Engine (MSDE 2000) =

Article ID: 324998

Article Last Modified on 3/29/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)

-



This article was previously published under Q324998



IN THIS TASK

 * SUMMARY
 * System Requirements for MSDE 2000
 * How to Obtain MSDE 2000
 * MSDE 2000 Licensing
 * How to Install MSDE 2000
 * REFERENCES



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

back to the top

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 database engine:
 * 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), or later
 * 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

Processor
 * A computer with a Pentium processor that must be running a minimum of 166 MHz.

Memory
 * 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 requirements.

Hard Disk
 * 44 MB minimum of free hard disk space.

Other
 * Microsoft Internet Explorer version 5.0, or later.

NOTE: You must install Microsoft Windows NT 4.0 Service Pack 5, or later, before you install Microsoft Internet Explorer version 5.0.

back to the top

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 1-800-360-7561.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

284230 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:

http://www.microsoft.com/downloads/details.aspx?FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147

back to the top

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:

http://www.microsoft.com/sql/prodinfo/previousversions/msde/msdeuse.mspx

back to the top

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 2000:
 * As a stand-alone installation by using the Windows Installer package that is included with the SQL Server Setup executable.

-or-


 * 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 file.

For more information about using the Setup.exe file and the various command-line switches, see the &quot;SQL Server 2000 Desktop Engine Setup&quot; topic in SQL Server Books Online.

Embedded MSDE Adaptation

You can consider consuming MSDE 2000 merge modules into your custom application setup. This &quot;Embedded MSDE Adaptation&quot; 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:

322228 Embedding MSDE 2000 Setup into the setup of custom applications (White paper)

back to the top

