DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 324998 - Last Review: June 19, 2014 - Revision: 7.0

 

On This Page

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.

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.

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  (http://support.microsoft.com/kb/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 (http://www.microsoft.com/downloads/details.aspx?FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147)


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 (http://www.microsoft.com/sql/prodinfo/previousversions/msde/msdeuse.mspx)


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 "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:
322228  (http://support.microsoft.com/kb/322228/ ) Embedding MSDE 2000 Setup into the setup of custom applications (White paper)

References

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
281983  (http://support.microsoft.com/kb/281983/ ) PRB: Cannot specify instance name using SQL Server 2000 merge modules
299795  (http://support.microsoft.com/kb/299795/ ) 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:
http://msdn2.microsoft.com/en-us/library/ms811304.aspx (http://msdn2.microsoft.com/en-us/library/ms811304.aspx) http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp (http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp)


Keywords: 
atdownload kbhowtomaster KB324998
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support