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:
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.
If you are a Small Business customer, find additional troubleshooting and learning resources at the Support for Small Business site.
The Replication Agent that is running on the server may not
restart when a named instance of SQL Server is removed from the server and
replication is configured on the server. When you remove a named instance of
SQL Server, the registry entries that relate to the Replication Agent are
removed from the server. This behavior may also occur when the 8.3 name
creation on the NTFS file system partition is disabled on the computer where
SQL Server is installed. You disable 8.3 name creation on the NTFS partition by
setting the NtfsDisable8dot3NameCreation registry key to 1.
Run the batch file you created in step 2b from the
\Microsoft Sql Server\80\Com folder.
Restart the SQL Server Agent service.
Method 2 Rebuild the registry. To do this, use these steps:
Insert the Microsoft SQL Server 2000 disk in the CD-ROM
drive. If the disk does not run automatically, double-click Autorun.exe in the
root directory of the disk.
Click SQL Server 2000 Components, and
then click Install Database Server.
In the Welcome screen of the SQL
Server Installation Wizard, click Next.
In the Computer Name dialog box, click
In the Installation Selection dialog
box, click Advanced Options.
In the Advanced Options dialog box,
click Registry Rebuild, and then click Next.
You will see a message that informs you that Setup rebuilds
the registry based on information you supply in the subsequent screens.
Caution: You must enter the same choices for the setup options as you did
for the initial installation. If you do not know or are not sure of this
information, do not use this registry rebuild process. Instead, you must remove
and re-install SQL Server to restore the registry. To prepare for the registry
rebuild, enter the same information and options that you entered during the
initial installation of SQL Server in the setup screens as they appear.
Note: Rebuilding the registry includes re-copying external components
such as Microsoft Data Access Components (MDAC) and Microsoft Distributed
Transaction Coordinator (MS DTC).