SQL Server encountered error 0x80070218.

Applies to: Microsoft SQL Server 2008 Developer Edition.
 

Problem Description.
 

I was trying to perform a Full-Text search on a table I created for testing purposes. The query was the following:

 

SELECT * FROM FTTable WHERE CONTAINS(FTText, '"caracteres"')


When I executed the query for the first time I received the following error message:


Msg 30046, Level 16, State 1, Line 1
SQL Server encountered error 0x80070218 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.


Based on the error message, I opened SQL Server Configuration Manager and verified that the "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" was running, but anyway I ran the sp_fulltext_service command as shown below and as suggested on the error message:


sp_fulltext_service 'restart_all_fdhosts'

The above command ran successfully but I was still getting the same error message, after trying to run the SELECT statement again.

I tried then to delete and recreate the Full-text catalog and the Full-text index but obtained the same error message as result.

Solution.

After trying all steps mentioned above I opened SQL Server Configuration Manager again and noticed the Local Service account was running the "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" service.






I have specified a local Windows account as a service account for the "SQL Server (MSSQLSERVER)" service when I installed SQL Server on that computer, so I decided to replace Local Service by that Windows Account as service account for "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" service. I dropped and recreated the Full-text catalog and index, run the SELECT statement again, and this time it executed successfully.




 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.