美文网首页
SQL-SERVER fulltext_service报错

SQL-SERVER fulltext_service报错

作者: 熊本猫 | 来源:发表于2019-04-11 12:02 被阅读0次

报错:
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启动成功。

相关文章

网友评论

      本文标题:SQL-SERVER fulltext_service报错

      本文链接:https://www.haomeiwen.com/subject/hqctwqtx.html