Rank: Advanced Member
Groups: Member
Joined: 3/24/2008
Posts: 461
Points: 1,275
Location: South Florida USA
|
Error: Quote:
Msg 30046, Level 16, State 1, Line 1
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.
Solutions: http://www.eggheadcafe.com/software/aspnet/34185324/sql08-fulltextindex-setup.aspxhttp://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8b33c58e-9d6f-462a-9a6a-1784946bb073?prof=requiredQuote:
If you cannot start the fdhost, please check the permission of FDLauncher Service logon account. Do you specify a user account for FDLauncher service during setup? If you didn't specify user account for FDLauncher Service, by default, FDLauncher is configured using the Local Service account. This account is not added to the SQLServerFDHostUser$<MachineName>$MSSQLSERVER group. To work around the issue, you need to assign Local Service account (or logon account of FDLauncher Service) to SQLServerFDHostUser$<MachineName>$MSSQLSERVER group. Then restart fdhost using sp_fulltext_service 'restart_all_fdhosts' procedure.
Code:
EXEC sp_fulltext_service 'restart_all_fdhosts'
|
