You cannot install MSDE 2000 from the MSDE2000 Folder of the Office XP installation CD-ROM (295185)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295185
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you use the Add/Remove Programs tool in Control Panel to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) from the MSDE2000 folder of the Microsoft Office XP installation CD-ROM, you may find that nothing is installed. Setup may start the Windows Installer program but then return to the MSDE 2000 installation dialog box after a few seconds. If you click Finish in the MSDE 2000 installation dialog box, you may receive the following error message:
The instance name specified is invalid.

CAUSE

This behavior can occur if you are trying to install a default instance of MSDE 2000 on a computer that has a default instance of SQL Server 7.0 already installed.

RESOLUTION

To resolve this behavior, install a named instance of MSDE 2000. Follow these steps:
  1. Click Start, and then click Run.
  2. In the Run box, type Command, and then press ENTER.
  3. At the command prompt, to install a named instance of MSDE 2000, type the following command, and then press ENTER Drive:\MSDE2000\Setup.exe INSTANCENAME="Name"

    where Drive is the drive letter of your CD-ROM or DVD-ROM drive and Name is the name of the new instance of MSDE 2000.

  4. Follow the on-screen instructions to complete the installation.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. On a computer that has Windows 2000 Server and a default instance of SQL Server 7.0 installed, insert the Office XP installation CD into the CD-ROM or DVD-ROM drive.
  2. Click Start, point to Settings, and then click Control Panel.
  3. Double-click Add/Remove Programs.
  4. In the Add/Remove Programs dialog box, click Add New Programs, and then click CD or Floppy.
  5. In the MSDE2000 folder on the CD-ROM, browse to the Setup.exe file, and then follow the on-screen instructions to complete the installation.
Modification Type:MinorLast Reviewed:8/12/2004
Keywords:kberrmsg kbprb kbsetup KB295185
©2004 Microsoft Corporation. All rights reserved.