Microsoft KB Archive/823467

= BUG: You cannot start the SQL Server Agent Service for an instance of SQL Server or the SQL Server 2000 Desktop Engine that has the same instance name as a previously uninstalled instance of the SQL Server 2000 Desktop Engine (Windows) =

Article ID: 823467

Article Last Modified on 8/13/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Standard Edition

-



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
You may not be able to start the SQL Server Agent Service for your instance of Microsoft SQL Server 2000 or of the Microsoft SQL Server 2000 Desktop Engine SP3 (or later). This problem may occur when all the following conditions are true:
 * 1) One of the following actions occurs:
 * 2) * You remove an instance of the SQL Server 2000 Desktop Engine SP3 (or later).
 * 3) * You remove an instance of the SQL Server 2000 Desktop Engine (Windows).
 * 4) You install an instance of the SQL Server 2000 Desktop Engine SP3 (or later) or SQL Server 2000.
 * 5) The instance name of your current instance of the Microsoft SQL Server 2000 Desktop Engine SP3 (or later), of the SQL Server 2000 Desktop Engine (Windows), or of SQL Server 2000 is the same as the instance name of the previous instance of the SQL Server 2000 Desktop Engine (Windows) or of the SQL Server 2000 Desktop Engine SP3 (or later).



WORKAROUND
To work around this problem, remove the following registry key manually after you remove the instance of the SQL Server 2000 Desktop Engine (Windows) or the SQL Server 2000 Desktop Engine SP3 (or later):

To do this, follow these steps:

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.  Click Start, and then click Run. In the Open box, type regedit . Click OK. In Registry Editor, locate and then select the following registry key:

 In the right pane, locate the  registry value, right-click the registry value, and then click Delete. Close Registry Editor. Start the SQL Server Agent service.</li></ol>

Note You may notice that you can start the SQL Server Agent service after you remove the registry key.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section of this article.

<div class="moreinformation_section">

MORE INFORMATION
When you try to start the SQL Server Agent service, the startup code for the SQL Server Agent service verifies whether the following registry value exists:

If the registry value exists, the SQL Server Agent automatically quits. The SQL Server 2000 Desktop Engine SP3 (or later) and SQL Server 2000 support this feature. Because the registry value is not removed when you remove the SQL Server 2000 Desktop Engine (Windows) or the SQL Server 2000 Desktop Engine SP3 (or later), the problem that is mentioned in the &quot;Symptoms&quot; section of this article occurs.

The SQL Server 2000 Desktop Engine (Windows) does not support the SQL Server Agent feature. Therefore, when you install the SQL Server 2000 Desktop Engine (Windows) with the same instance name as the instance name of the previous instance and then the registry value for the previous instance is not removed, the functionality of the current instance is not affected. If the instance of the SQL Server 2000 Desktop Engine (Windows) is upgraded to SQL Server 2000, the  registry value must be manually removed. Therefore, after the upgrade process, you can start the SQL Server Agent service.

Additional query words: WMSDE MSDE

Keywords: kbbug kbregistry kbservice kbsetup kbpreinstall kbpending KB823467

-

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

© Microsoft Corporation. All rights reserved.