SQL Server issue 1-sql server encountered error 0x80070422/0x8007042d

Perform the Full-text search query operation for SQL Server 2014 today: SELECT * FROM table where contains (summary, ' Smith ')

Report the following error:

MSG 30046, Level A, State 1, line 1
SQL Server encountered error 0x8007042d while communicating with Full-text filter Daemon host (FDHost) process. Make sure, 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 Instan Ce.

Well, the elder brother later solved the problem:

The problem is probably caused by the Fulltextsearch Service outage, but it's not the only way to look down:

#1, Open the Services panel and make sure the service below is working properly

SQL full-text Filter Daemon Launcher (MSSQLSERVER)

#2, checking of accounts

However, I still have the error report above, despite running it successfully. After more research, I found that there was a problem: I ran SQL Server under a domain account, and fulltext search was not used for this account, possibly the default account.

So, I configured the domain account to this service and restarted it. And in SQL Server, run " exec sp_fulltext_service ' restart_all_fdhosts ' ".

The full-text index of Fulltext search is rebuilt and the line retrieval operation is done. Bingo, running well.

SQL Server issue 1-sql server encountered error 0x80070422/0x8007042d