Microsoft KB Archive/899580

= 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 =

Article ID: 899580

Article Last Modified on 2/14/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 64-bit Edition

-





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):
 * 1) Save a copy of the MSSearch.inf file to a backup folder.

Typically, the MSSearch.inf file is located in the :\Program Files\Common Files\System\MSSearch\Bin folder.
 * 1) Delete the MSSearch.inf file.
 * 2) 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
To work around this problem, uninstall the new clustered instance. Then, reinstall the new clustered instance.



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

Keywords: kbuninstall kbsetup kbsql kbdatabase kbprb KB899580

-

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

© Microsoft Corporation. All rights reserved.