March 24, 2010 at 5:56 pm
Hello my friends,
Seems like my joys of SQL2008 is still going strong. So the latest in the saga is I'm now experiencing issues with full-text filters on two servers that i upgraded from 2005 - 2008. Then i try to use it (via the website) I'm receiving.
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 make sure that the FDHost is running in services and it is, so i ran sp_fulltext_service 'restart_all_fdhosts', and guess what, that's right the exact same error message. Guess what happens when i restart the server instance??? Yep you guessed it the very same error message. So as much help as SQL is i was wondering(well hoping) if anyone could suggest some advice on tackling this problem
Many thanks
Mr J 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
March 24, 2010 at 6:03 pm
Have you tried suggestions contained in http://www.eggheadcafe.com/software/aspnet/34185324/sql08-fulltextindex-setup.aspx or other top Google page links?
March 24, 2010 at 6:19 pm
Yes my friend,
It is similar in the fact that FTI service stopped is stopped in SQL2008 configure, and i am unable to start it because it keeps telling me.
The Service cannot be started, either it is disabled or because it has no enabled devices associated with it. [0x80070422]
Problem is his solution was to open SQL2005 and stop the 2005FTI, well i dont have any services runnin when i open that, so access denied on that solution. Also he suggests using a local account rather than a domain and still access denied.
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
March 25, 2010 at 6:03 am
Confused.
If you go to SQL Server Configuration Manager, and look under SQL Server Services, is the SQL Full-text Filter Daemon Launcher running or not? If you have more than one instance installed, make sure you check the right one.
Is SQL Server 2005 also installed on the machine?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 25, 2010 at 5:49 pm
Its fix now.
The symptoms were, within SQL2008 configure manager the said SQL Full-Text Filter...... was stopped. When i tried to start, it told me it was disable or unable to enable the device. Naturally my next step was to go to services.msc to see if the service was really disabled but it wasn't, hence the issue.
What the problem ended up being, was a junior network administrator opened the firewall to allow access via all ports a few months ago, and the server had been affected with a bot, that had affected the service. After a few panicked moments, was able to remove it and then proceed to highlight the stupidity of openin the firewall to the na.
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
March 25, 2010 at 10:44 pm
Very scary.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply