Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Microsoft Data Engine Setup Stops Responding While Connecting to Server


View products that this article applies to.

This article was previously published under Q235432
Moderate: Requires basic macro, coding, and interoperability skills.

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

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 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry

↑ Back to the top


Symptoms

After the Microsoft Data Engine (MSDE) Setup program copies files to your computer, it stops responding during the "Connecting To Server" phase.

↑ Back to the top


Resolution

To resolve this problem, follow these general steps, which are discussed in more detail in subsequent sections of this article:
1.Remove the failed MSDE installation.
2.Add the following networking components:
Client for Microsoft Networks
Dial-Up Adapter
TCP/IP protocol

3.Restart Windows.
4.Re-install the MSDE.

Completely Remove MSDE

1.In Windows Explorer, delete the \MSSQL7 folder and its contents.
2.Start the Registry Editor (Regedit.exe).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.

3.Locate and delete the MSSQLServer key under the following key of your registry:
   HKEY_LOCAL_MACHINE\Software\Microsoft
					

Add Additional Networking Components to Windows 95 or Windows 98 Computers

1.Click Start, point to Settings, and then click Control Panel.
2.In Control Panel, double-click the Network icon.
3.In the Network dialog box, click Add.
4.In the Select Network Component Type list, select Client, and then click Add.
5.In the Select Network Client dialog box, select Microsoft in the Manufacturers list, and click Client for Microsoft Networks in the Network Clients list.
6.Click OK.
7.When you are prompted to select a Network Adapter, click Microsoft in the Manufacturers list, and in the Network Adapters list, click Dial-Up Adapter.

The TCP/IP protocol stack will be automatically installed as part of the Dial-Up Adapter.
8.Click OK on this and the following dialog box.
9.If prompted, insert the media for your operating system.
10.Restart Windows when prompted.

You should now be able to install the MSDE successfully.

↑ Back to the top


Status

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

↑ Back to the top


More information

Steps to Reproduce Behavior

1.Locate a computer that meets either of these criteria:
The computer does not have a network card, any networking client, or any networking protocol installed.
The computer does not have any networking client, Dial-Up Adapter, or networking protocol installed.

2.Run SetupSQL.exe in the \SQL\X86\Setup folder of CD1 of Microsoft Office 2000 or Microsoft Access 2000.
3.Note that the Setup program stops responding after displaying "Connecting to Server."

↑ Back to the top


References

For more information about MSDE, click Microsoft Access Help on the Help menu, type "Work with a Microsoft Access Project" in the Office Assistant or the Answer Wizard, and then click Search to view the "Learn about Microsoft Data Engine (MSDE)" topic.

↑ Back to the top


Keywords: KB235432, kbpending, kbclientserver, kbbug

↑ Back to the top

Article Info
Article ID : 235432
Revision : 3
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 372