The Full Text resource fails when you install a new clustered instance after you apply SQL Server 2000 Service Pack 4 to an existing clustered instance (899580)

Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

SYMPTOMS

After you apply Microsoft SQL Server 2000 (64-bit) Service Pack 4 (SP4) to an existing clustered instance of SQL Server 2000 (64-bit), the Full Text resource fails when you install a new clustered instance of SQL Server 2000 (64-bit). This problem occurs in both the default instance and the named instance.

Note This problem only occurs when you install the first new clustered instance of SQL Server 2000 (64-bit) after you apply SQL Server 2000 (64-bit) SP4. This problem does not occur in any new clustered instances that you install after the first new clustered instance.

CAUSE

This problem occurs because the Full Text resource Setup program (Ftsetup.exe) does not run before SQL Server tries to bring the Full Text resource online. Therefore, the Full Text resource is not correctly configured for the new clustered instance.

After you install a new clustered instance of SQL Server 2000 (64-bit), you must restart the computer to replace some files that Ftsetup.exe uses. Ftsetup.exe is delayed to run upon restart instead of immediately. Therefore, when SQL Server tries to bring the Full Text resource online immediately, the Full Text resource is not correctly configured for the new clustered instance. Additionally, Ftsetup.exe still cannot configure the Full Text resource correctly after you restart the computer.

RESOLUTION

To avoid this problem, follow these steps before you install a new clustered instance of SQL Server 2000 (64-bit):

Save a copy of the MSSearch.inf file to a backup folder.

Typically, the MSSearch.inf file is located in the Drive:\Program Files\Common Files\System\MSSearch\Bin folder.
Delete the MSSearch.inf file.
Repeat step 1 and 2 on each node in the cluster.

After you follow these steps, you will not have to restart the Full Text resource when you install the new clustered instance of SQL Server.

WORKAROUND

If you are already experiencing this problem, you can use one of the following methods to work around this problem.

Method 1: Uninstall and then reinstall the new clustered instance of SQL Server 2000 (64-bit)

If you have already installed the new clustered instance of SQL Server 2000 (64-bit), you can uninstall the new clustered instance and then reinstall the new clustered instance.

Method 2: Manually run Ftsetup.exe

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

You can reinstall the Full Text resource by manually running Ftsetup.exe. However, before you can manually run Ftsetup.exe, you must perform the following cleanup steps.

Note You must perform these cleanup steps on all nodes in the cluster group.

Delete the NewInstanceName subkey under the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gathering Manager\Applications
Delete the NewInstanceName subkey under the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications
Locate the shared data directory of the new clustered instance, and then delete everything under the FTData folder.

Note Typically, the FTData folder includes some .0 files, some .1 files, and a SQLServer$NewInstanceName folder.

After you have completed the cleanup steps, you can reinstall the Full Text resource.

Note Make sure that you only run Ftsetup.exe from the node from which you originally ran the SQL Server Setup program. Also, make sure that the node has control of the shared drive.

To manually run Ftsetup.exe, you can use the following command-line command:

"Path of the new clustered instance Bin folder\ftsetup.exe" SQLServer$InstanceName SQL Server Account 1 0 1 0

Note InstanceName is the name of the new clustered instance of SQL Server. SQL Server Account is the account under which SQL Server runs. This account must have local administrator permissions on the node from which you run Ftsetup.exe.