Apr 16, 2014

SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance

When we run a very simple full text search query in server for examples:

SELECT *
FROM [ExactHelp].[dbo].[tblActiveProcess]
WHERE CONTAINS(vcProcessName,'a')

We may get error message like:

SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

Cause: Your full-text filter daemon service is not running.
Solution: We have to start the service "Sql Full-text filter daemon Launcher".

Step 1: In run type: services.msc and press enter.
Step 2: Right click on "Sql Full-text filter daemon Launcher" and click on properties.

Start sql server full text search daemon Launcher

Step 3: If start type is disable then choose either automatic or manual then click on apply then start the services then click on OK button.


Enable and start services FULL TEXT SEARCH

No comments:

Post a Comment