Microsoft KB Archive/308853

= BUG: SP1 Regression: Uninstalling SQL Server 2000 Does Not Remove the MSSQLServerADHelper Service =

Article ID: 308853

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 1

-



This article was previously published under Q308853



BUG #: 355361 (SHILOH_BUGS)



SYMPTOMS
MSSQLServerADHelper is a service installed by the SQL Server Setup program that handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications that are running on the computer. There is only one MSSQLServerADHelper service on a computer for all of the instances of Microsoft SQL Server 2000.

On computers that are running SQL Server 2000 Service Pack 1 (SP1), uninstalling all the instances of Microsoft SQL Server 2000 does not remove the MSSQLServerADHelper service.

This problem does not occur on SQL Server 2000, but does occur with SQL Server 2000 Service Pack 1.



CAUSE
The problem occurs because the uninstall process fails to remove a registry key.



WORKAROUND
To work around this problem, delete the registry key that was not removed by the uninstall process.

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

To delete the registry key, use these steps:  Start the Registry Editor (Regedt32.exe). Locate the the following key in the registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper

 On the Edit menu, click Delete, and then click Yes to confirm deletion of the key. Quit the Registry Editor.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 SP1.

Keywords: kbbug kbpending KB308853

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.