Knowledge Base

Microsoft SQL Server 2000 Desktop Engine is not installed by Office XP Setup

Article ID: 290627

Article Last Modified on 8/18/2004

APPLIES TO

Microsoft Access 2002 Standard Edition

This article was previously published under Q290627

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

For a Microsoft Access 2000 version of this article, see 218812.

SUMMARY

You cannot install the Microsoft SQL Server 2000 Desktop Engine through the Microsoft Office XP Setup program. There is a separate Setup program that you use to install the SQL Server 2000 Desktop Engine.

NOTE: The previous version of Microsoft SQL Server 2000 Desktop Engine is named Microsoft Data Engine (MSDE).

MORE INFORMATION

The Microsoft SQL Server 2000 Desktop Engine is a technology that provides local data storage that is compatible with Microsoft SQL Server 2000. Because the SQL Server 2000 Desktop Engine shares the same data engine as Microsoft SQL Server, most Microsoft Access projects or client/server applications run on either version unchanged.

NOTE: Unlike Microsoft SQL Server 2000, the SQL Server 2000 Desktop Engine has a 2-gigabyte database size limit, does not support Symmetrical Multiprocessing (SMP) on Microsoft Windows 95 or later, and when using Transactional replication, cannot be a replication publisher (although it can act as a replication subscriber).

Installing SQL Server 2000 Desktop Engine

If you have the Microsoft Data Engine (MSDE) installed, it is best to uninstall it before you install SQL Server 2000 Desktop Engine.

The SQL Server 2000 Desktop Engine Setup program installs Microsoft Data Access Components (MDAC) version 2.6 (if MDAC 2.6 or later is not already installed on the computer).

To install SQL Server 2000 Desktop Engine, follow these steps:

Insert the Microsoft Office XP CD 1 into the CD-ROM or DVD-ROM drive.
In Windows Explorer, locate the following folder:

\MSDE2000
In the MSDE2000 folder, double-click the Setup.exe file.

Upgrading MSDE to SQL Server 2000 Desktop Engine

If you are going to upgrade MSDE to SQL Server 2000 Desktop Engine, you should do so before installing Office XP Developer. The upgrade described here will delete files from the MSSQL\Bin folder on your computer. Therefore, you will be required to reinstall Office Developer after this upgrade.

To upgrade SQL Server 2000 Desktop Engine, follow these steps:

Insert the Microsoft Office XP CD 1 into the CD-ROM or DVD-ROM drive.
In Windows Explorer, locate the following folder and then copy the MSDE2000 folder to a folder on the local computer (C:\MyFolder). :

\MSDE2000
For Microsoft Windows 98 or Microsoft Windows Me, edit the [Options] section of the Setup.ini file as follows:
```
   [Options]
   UPGRADE=1
   UPGRADEUSER=sa
                        
```
For Microsoft Windows NT 4.0 or Microsoft Windows 2000, edit the [Options] section of the Setup.ini file as follows:
```
   [Options]
   UPGRADE=1
                    
```
Use the following switches to run Setup from the command line:

NOTE: In the following statement, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when you type this statement.

C:\MyFolder\setup.exe /i Setup\SqlRun01.msi /settings setup.ini _
/l*v c:\msde_install.txt

Additional query words: msde 2000 msde2k 8.0

Keywords: kbhowto kbclientserver KB290627

Microsoft KB Archive/290627

Contents