Microsoft KB Archive/827449

From BetaArchive Wiki

Article ID: 827449

Article Last Modified on 3/6/2007


APPLIES TO

  • Microsoft SQL Server 2000 Standard Edition


Important This article contains information about how to modify the registry. Make sure that you 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


SUMMARY

In Microsoft SQL Server 2000, you may not be able to create full-text catalogs. Additionally, when you try to start the Microsoft Search service (Full-Text Service), you may receive an error message. If these problems occur, you must manually reinstall the Microsoft Search service. This article describes how to manually reinstall the Microsoft Search service. To use the information in this article, make sure that you meet the following prerequisites:

  • You must have access to the setup files for Microsoft SQL Server 2000.
  • You must have access to the setup files for the most recent SQL Server 2000 service pack that is installed on your instance of SQL Server.

To reinstall the Microsoft Search service, follow these steps:

  1. Remove the Microsoft Search service from your computer. To do so, remove the corresponding registry entries and the corresponding folder.
  2. Install the Microsoft Search service. To do so, run the Searchstp.exe program and the Ftsetup.exe program.
  3. Upgrade the Microsoft Search service to the most recent SQL Server 2000 service pack that is installed on your instance of SQL Server.


IN THIS TASK

INTRODUCTION

In Microsoft SQL Server 2000, you may not be able to create full-text catalogs. Additionally, when you try to start the Microsoft Search service (Full-Text Service), you may receive the following error message:

The System cannot find the path specified.

This problem may occur if the files or the registry keys that are related to the Microsoft Search service are missing. To resolve this problem, you must reinstall the Microsoft Search service on your computer. This step-by-step article describes how to manually reinstall the Microsoft Search service without affecting the corresponding instance of SQL Server.

Note These steps do not apply to a clustered instance or a virtual server. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254321 Clustered SQL Server do's, don'ts, and basic warnings




back to the top

Prerequisites

To use the information that is included in this article, make sure that you meet the following prerequisites:

  • You must have access to the setup files for Microsoft SQL Server 2000 to reinstall the Microsoft Search service. Therefore, if you used the SQL Server 2000 CD-ROM to install SQL Server on your computer, make sure that you have access to the SQL Server 2000 CD-ROM.
  • You must have access to the setup files for the most recent SQL Server 2000 service pack that is installed on your instance of SQL Server.

back to the top

Manually reinstall the Microsoft Search service

To reinstall the Microsoft Search service on your computer, follow these steps.

Note Before you reinstall the Microsoft Search service, back up your database files and your log files.

  1. Remove the Microsoft Search service. To do so, follow these steps:
    1. Stop the SQL Server services that correspond to your instance of SQL Server.
    2. Delete the registry keys that are related to the Microsoft Search service for your instance of SQL Server. To do so, follow these steps.

      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 the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
      1. Click Start, and then click Run.
      2. In the Run dialog box, type Regedit in the Open box, and then click OK.
      3. In Registry Editor, locate and then delete the following registry keys:
        • HKEY_LOCAL_MACHINE\Software\Microsoft\Search
        • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSCNTRS
        • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSEARCH
        • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSGATHERER
        • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSGTHRSVC
        • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSSINDEX
    3. Locate and then delete all the instances of the MSSearch folder from your computer. By default, the MSSearch folder is created by the SQL Server Setup program in the Installation Drive:\Program Files\Common Files\System folder. Microsoft recommends that you create a backup copy of the MSSearch folder on a computer other than the current computer.

      Note If you cannot delete the MSSearch folder from your computer, first delete the Msscntrs.dll file, and then delete the MSSearch folder. The Msscntrs.dll file provides the performance monitor counters for the Microsoft Search service. If you cannot delete the Msscntrs.dll file, close the Performance Monitor application on your computer. If your computer is a Compaq computer, make sure that the Compaq services are not running on your computer and make sure that the Compaq Insight Manager is stopped. If the Compaq services are running and you try to delete the Msscntrs.dll file, you may receive the following error message:

      Access is denied

    4. Restart your computer.

      Note Make sure that the SQL Server services that correspond to your instance of SQL Server are not running.
  2. Install the Microsoft Search service. To do so, follow these steps:
    1. Start the SQL Server services that correspond to your instance of SQL Server.
    2. For a default instance of SQL Server, run the following command at a command prompt to install the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for SQL Server 2000):

      "Full path of the SQL Server setup files:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer > C:\MySearchStp.log

      For a named instance of SQL Server, run the following command at a command prompt to install the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for SQL Server 2000):'

      "Full path of the SQL Server setup files:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer$Instance Name > C:\MySearchStp.log

      Note After you run the command, you must wait for the disk activities and the network activities to stop. If the command runs successfully, all the registry keys that were previously deleted are now available in Registry Editor. Additionally, the MSSearch folder is re-created.
    3. Use the Services console to make sure that the Microsoft Search service is running.

      Note When the command has finished running, the Microsoft Search service starts. Currently, the instance of SQL Server is not aware of the Microsoft Search service. Therefore, you must make sure that Microsoft Search service is running.
    4. For a default instance of SQL Server, run the following command at a command prompt to configure the instance of SQL Server to use the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for SQL Server 2000):

      "Full path of the SQL Server setup files:\x86\FullText\ftsetup.exe" SQLServer Domain Name\User Account 1 0 0 0 > C:\MyFTSetup.log

      For a named instance of SQL Server, run the following command at a command prompt to configure the instance of SQL Server to use the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for SQL Server 2000):'

      "Full path of the SQL Server setup files:\x86\FullText\ftsetup.exe" SQLServer$Instance NameDomain Name\User Account 1 0 0 0 > C:\MyFTSetup.log

      Note When you run the command, you must use a domain name and a user account that have the same permissions as the domain name and the user account that were used when the instance of SQL Server was installed. The user account must also have the same permissions to the folders and to the keys. To view the original domain name and user account, you can use the most recent SQL Server setup log file (SqlstpN.log). In the SqlstpN.log file, locate the line where the SQL Server Setup program ran the Ftsetup.exe program. Additionally, make sure that the information is the same as the information that is included in the command.
    5. Make sure that the MSSQL75 registry value exists in the following registry key on your computer, and then make sure that the value of the MSSQL75 registry value is set to sqlfth75.sqlfth75.1:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ProtocolHandlers

      If the registry value is missing on your computer, you must manually create the MSSQL75 registry value. To do this, follow these steps:

      1. Click Start, click Run, type Regedit, and then click OK.
      2. In Registry Editor, locate and then select the following registry key:

        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ProtocolHandlers

      3. In the right pane, create the MSSQL75 registry value with the following specifications:
        • Value Type: Reg_SZ
        • Value Data: sqlfth75.sqlfth75.1
      4. Close Registry Editor.
      5. Restart your instance of SQL Server.
      6. Restart the Microsoft Search service.
      Note If the MSSQL75 registry value is missing, the Full-Text search may not populate the catalogs successfully.
  3. Upgrade the Microsoft Search service to the most recent SQL Server 2000 service pack that is installed on your instance of SQL Server. To do so, follow these steps:
    1. For a default instance of SQL Server, run the following command at a command prompt to install the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for the SQL Server 2000 service pack that is currently installed on your instance of SQL Server):

      "Full path of the SQL Server setup files:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer > C:\MySearchStp.log

      For a named instance of SQL Server, run the following command at a command prompt to install the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for the SQL Server 2000 service pack that is currently installed on your instance of SQL Server): '

      "Full path of the SQL Server setup files:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer$Instance Name > C:\MySearchStp.log

      Note After you run the command, you must wait for the disk activities and the network activities to stop. If the command runs successfully, all the registry keys that were previously removed are now available in Registry Editor. Additionally, the MSSearch folder is re-created.
    2. Use the Services console to make sure that the Microsoft Search service is running.

      Note When the command has finished running, the Microsoft Search service starts. Currently, the instance of SQL Server is not aware of the Microsoft Search service. Therefore, you must make sure that Microsoft Search service is running.
    3. For a default instance of SQL Server, run the following command at a command prompt to configure SQL Server to use the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for the SQL Server 2000 service pack that is currently installed on your instance of SQL Server): '

      "Full path of the SQL Server setup files:\x86\FullText\ftsetup.exe" SQLServer Domain Name\User Account 1 0 0 0 > C:\MyFTSetup.log

      For a named instance of SQL Server 2000, run the following command at a command prompt to configure SQL Server to use the Microsoft Search service (where Full path of the SQL Server setup files is the folder that contains the setup files for the SQL Server 2000 service pack that is currently installed on your instance of SQL Server):'

      "Full path of the SQL Server setup files:\x86\FullText\ftsetup.exe" SQLServer$Instance NameDomain Name\User Account 1 0 0 0 > C:\MyFTSetup.log

      Note When you run the command, you must use a domain name and a user account that have the same permissions as the domain name and the user account that were used when the instance of SQL Server was installed. The user account must also have the same permissions to the folders and to the keys. To view the original domain name and user account, you can use the most recent SQL Server setup log file (SqlstpN.log). In the SqlstpN.log file, locate the line where the SQL Server Setup program ran the Ftsetup.exe program. Additionally, make sure that the information is the same as the information that is included in the command.

Although you can start the Microsoft Search service on a clustered instance of SQL Server, you may not be able to bring the full-text search engine online.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

back to the top

Keywords: kbregistry kbhowtomaster kbhowto KB827449



Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.


Retrieved from ‘https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/827449&oldid=334115’
the Creative Commons 3.0 ShareAlike (except the Microsoft KB Archive).
Powered by MediaWiki