We help IT Professionals succeed at work.

SQL Server Upgrade from 2005 to 2008 Full Text Issue

browe68
browe68 asked
on
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.
Comment
Watch Question

Author

Commented:
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

Commented:
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
Commented:
Oh, and definitely best if it is not installed on a domain controller - check out that downloadable document :)