How to manually reinstall the Microsoft Search service for an instance of SQL Server 2000 (827449)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
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 SUMMARYIn 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: - Remove the Microsoft Search service from
your computer. To do so, remove the corresponding registry entries and the
corresponding folder.
- Install the Microsoft Search service. To do so, run the Searchstp.exe program and the Ftsetup.exe program.
- Upgrade the
Microsoft Search service to the most recent SQL Server 2000 service pack that is installed on your instance of SQL Server.
INTRODUCTIONIn 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. back to the topPrerequisitesTo 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 topManually 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.
- Remove the
Microsoft Search service. To do so, follow these steps:
- Stop the SQL Server services that correspond to your
instance of SQL Server.
- 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 your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.- Click Start, and then click
Run.
- In the Run dialog box, type
Regedit in the Open box, and then click
OK.
- 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
- 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 - Restart your computer.
Note Make sure that the SQL Server services that correspond to your
instance of SQL Server are not running.
- Install the Microsoft Search service. To do so, follow these steps:
- Start the SQL Server services that correspond to your
instance of SQL Server.
- 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. - 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. - 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. - 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:- Click Start, click Run, type Regedit, and then click OK.
- In Registry Editor, locate and then select the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ProtocolHandlers - In the right pane, create the MSSQL75 registry value with the following specifications:
- Value Type: Reg_SZ
- Value Data: sqlfth75.sqlfth75.1
- Close Registry Editor.
- Restart your instance of SQL Server.
- Restart the Microsoft Search service.
Note If the MSSQL75 registry value is missing, the Full-Text search may not populate the catalogs successfully.
- 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:
- 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. - 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. - 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, regarding the performance or reliability of these products.
back to the top
Modification Type: | Minor | Last Reviewed: | 12/9/2005 |
---|
Keywords: | kbRegistry kbHOWTOmaster kbhowto KB827449 kbAudDeveloper |
---|
|
|
©2004 Microsoft Corporation. All rights reserved.
|
|