MS SQL Server Error 0x80070218

Plesk Servers > SQL > MSSQL

MS SQL Server Error 0x80070218Issue

When performing a full text search, the results time out with the following error:
 
SQL Server encountered error 0x80070218 while communicating with full-text filter daemon host

Cause
The cause for the "MS SQL Server Error 0x80070218" error is that the Log On user for the SQL Full-text Filter Daemon Launcher service is incorrect.

Resolution 
You will need to change the Log On user to Log On as Local System account. If you do not have a dedicated server these steps will need to be performed by a support technician.
  1. Log onto the server with an administrator account.
  2. Click Start > Run.
  3. Type services.msc press enter.
  4. In the Services window scroll down to SQL Full-text Filter Daemon Launcher and double click on it.
  5. In the Properties window click on the Log On tab.
  6. Select Local System Account.
  7. Click Apply and then OK.
  8. Right click SQL Full-text Filter Daemon Launcher and select Restart.
  9. Find SQL Server in the Services window.
  10. Right click and select Restart.
  11. Close the services window.
You should now be able to run your full text search again.

 

Add Feedback