[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
SQL Server encountered error 0x80070218

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.