Link to home
Start Free TrialLog in
Avatar of browe68
browe68

asked on

SQL Server Upgrade from 2005 to 2008 Full Text Issue

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.
Avatar of browe68
browe68

ASKER

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.
Avatar of Mark Wills
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.
 
ASKER CERTIFIED SOLUTION
Avatar of Mark Wills
Mark Wills
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial