Office Server Extensions Installation Prompts for SQL Server (236627)


The information in this article applies to:

  • Microsoft Office 2000 Server Extensions
This article was previously published under Q236627
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

When you install the Office 2000 Server Extensions, the Office Setup program prompts you for the name of your SQL Server, or you may receive the following error message:
Setup was unable to install the microsoft data engine. If you continue the installation, you will need to provide the name of another machine running Microsoft SQL Server 6.5 or greater. Do you want to continue?

CAUSE

If you have run the Office Setup program before, and stopped it prior to completion, the next time you run the Setup program, it will detect the C:\MSSQL7 folder, where SQL Server or Microsoft Data Engine (MSDE) has been previously installed.

NOTE: Installing Office 2000 Server Extensions with MSDE or SQL by using a terminal server is not supported and does not work. You must install at the computer console, or you can install remotely by using Net Meeting's Remote Desktop Sharing.

RESOLUTION

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

You must completely remove MSDE from your computer before you reinstall the Office Server Extensions. To remove MSDE completely, perform the following steps:
  1. Click Start, point to Settings, and then click Control Panel.
  2. Double-click the Services icon in Control Panel.
  3. Stop the MSSQLServer service.
  4. Close the Services window.
  5. Double-click the Add/Remove Programs icon in Control Panel.
  6. Select MSDE from the list and click Add/Remove to uninstall the program.
  7. Close the Add/Remove Programs window.
  8. Click Start, point to Programs, and then click Windows NT Explorer.
  9. Delete the C:\MSSQL7 folder and all of its contents.
  10. Click Start, and then click Run.
  11. In the command line, type "regedit" (without the quotation marks).
  12. Open the HKEY_LOCAL_MACHINE\Software\Microsoft registry key.
  13. Delete the MSSQLServer registry key, if present.
  14. Open the HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services registry key.
  15. Delete the MSSQLServer registry key, if present.
  16. Delete the SQLServerAgent registry key, if present.
  17. Restart the computer.
  18. Begin the installation of the Office Server Extensions.
  19. When prompted to enter a username and password for MSDE to use when connecting to the database, enter SA for the username and leave the password blank.

MORE INFORMATION

The installation of the Office Server Extensions requires that you have SQL Server 6.5 or later installed on your computer. If you do not have SQL Server 6.5 or later, then the Microsoft Data Engine (MSDE) is installed in C:\MSSQL7.

If a previous attempt to install the Office Server Extensions is stopped, the next time you attempt to install the Office Server Extensions, the installation program may read the C:\MSSQL7 folder as SQL Server instead of MSDE. This causes the installation program to prompt you for the name of your SQL Server.
Modification Type:MajorLast Reviewed:6/11/2002
Keywords:kbprb KB236627
©2002 Microsoft Corporation. All rights reserved.