SolutionCottage.com
Posted  18 Mar 2009 - 21:19:48

Category: SQL


0x80070218 error performing 'contains' full text search

Issue:
When performing a CONTAINS statement using full text search in Microsoft SQL Server you get the error message:

"SQL Server encountered error 0x80070218 while communicating with full-text filter daemon host (FDHost) process."

Solution:

  1. Start / All Programs / SQL Server 2008 / Configuration Tools / SQL Server Configuration Manager.
  2. Right click the "SQL Full-text Filter Deamon Launcher" and choose Properties.
  3. For "Log on as:" choose Network Service.
  4. Restart the service using the buttons lower in this dialog.
  5. Perform the query again.



Marked as helpful by 42 users




6 comments:

10/2/2012 5:30:46 PM  Egor  wrote:

Thank you! It's really works!


6/22/2012 11:05:21 PM  Ivan Rico  wrote:

great, helped me


4/12/2012 12:46:49 PM  Margaret  wrote:

Mine is already selected as Network Service. I restarted but still get the same error.


1/11/2010 12:02:22 PM  Robert  wrote:

I think it might have to be Network Service because that's what the SQL Server service is running under.


9/29/2009 1:16:33 PM  Ossian  wrote:

ZOMG thx a bunch!!!


9/28/2009 5:22:03 PM  Fabricio  wrote:

Thanks!!! works at once, but can you tell why must be selected Network service instead of Local Service? Thanks!!!









© SolutionCottage 2008-2011 9/24/2017 1:01:21 PM