报错:
SQL Server encountered error 0x8007042d 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.
解决办法
打开“服务”(运行services.msc),找到服务SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
右键该服务,打开属性
切到“登录”选项卡
清空NT Service\MSSQLFDLauncher账号的密码(NT Service\MSSQLFDLauncher这个是一个虚拟账号,默认是没有密码的,官方文档:https://docs.microsoft.com/zh-cn/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-2017
)
保存并启动服务
然后打开SQL Server Management Studio
运行sp_fulltext_service 'restart_all_fdhosts'
至此 full-text filter daemon host启动成功。