SQL Server encountered error 0x80070218.
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:
I tried then to delete and recreate the Full-text catalog and the Full-text index but obtained the same error message as result.
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.
.Send mail to
questions or comments about this web site.