Error Msg :
Msg 30046, Level 16, State 1, Line 1
SQL Server encountered error 0x80070422 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 faced this error when I am searching records from SQL Server 2008.
Solution :
Step 1 : Go to Start --> Run --> Services.msc
Step 2 : Click on SQL Full-text Filter Daemon Launcher (MSSQLSERVER) If it is Disable then Start Services
Step 3 : Click Properties --> Go To Log on Tab
Step 4 : Change Credential As Screenshot
Step 5 : Restart Service Again
Step 6 : Go To SQL Server Management Studio
Step 7 : Run Query - sp_fulltext_service 'restart_all_fdhosts'
Step 8 : Msg Displayed : Command Completed Successfully.
Step 9 : Smile
No comments:
Post a Comment