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.