We help IT Professionals succeed at work.

SQL Server Upgrade from 2005 to 2008 Full Text Issue

browe68 asked
I upgraded my SQL Server from 2005 to 2008.  Everything works fine except the full-text search.

I get this error when running a query....

"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."

I have searched and seen suggestions to restart/change the service account login for FDHOST, however, I am running into problems with that too as I get a WMI Error "A new member could not be added to a local group because the member has the wrong account type"

My Server Configuration is I have a Default Install (SQL 2005) and a named instance (SQL 2008) on the same machine.    This machine is also a Domain Controller (if that matters).

What login should the services use:  SQLSERVER, SQL AGENT, FULL TEXT DAEMON Launcher.

Thanks for any help.
Watch Question


Solved: by changing the user account to be different from the SQL SERVER start up account (they were the same).   On the Domain Controller, I used a domain user that I created name sqlagent2.

That seems to work.
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Yep, absolutely....

Always best to use domain users specifically for any of the SQL Services - and make them seperate for each service and you will always be better off.

It is discussed in the downloadable document : http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

From 2005 onwards, always best to seperate the services : http://technet.microsoft.com/en-us/library/ms143504.aspx

Notice what it says for Full-Text search :
>> Use an account different than the account for the SQL Server service.
>> Stopped only if an account is not specified on Windows Server 2003 or Windows XP.
Topic Advisor, Page Editor
Distinguished Expert 2018
Oh, and definitely best if it is not installed on a domain controller - check out that downloadable document :)