如何在SQL Server 2014中启用/安装全文搜索 [英] How to enable/install Full Text Search in SQL Server 2014

问题描述

这个问题可能有一个非常简单的答案，但是我不知道如何在SQL Server 2014中启用全文搜索.

There is probably a very simple answer to the question but I have no idea how I'm going to enable Full Text Search in SQL Server 2014.

最近两个小时我一直在网上搜索，一些有关SQL Server 2012的帖子说它是安装过程中的功能，但是我去了那里，我没有启用它的选项.

I've been searching the net for the last couple of hours, some posts about SQL Server 2012 said it's in the features during installation but I went there and I had no options to enabled it.

自从我运行

select SERVERPROPERTY('IsFullTextInstall')

得到0.

要对此进行更多扩展，我创建了全文目录，但是如果我右键单击表，则全文索引"选项将显示为灰色.

To expand on this more, i've created a Full Text Catalog but if I right click on a table the Full-Text Index option is grayed out.

如果我尝试运行创建全文索引命令，也会收到错误消息

Also if I try run a create Full Text Index command I get the error

未安装全文搜索，或者无法加载全文组件.

Full-Text Search is not installed, or a full-text component cannot be loaded.

推荐答案

不知道您是否具有SQL Server 2014的Express版本，但是我遇到了同样的问题，因此解决了下载SQL Server 2014 Express Advanced的问题.服务，然后启动安装程序，然后在可安装功能列表中的实例功能"下选择全文和语义提取"，然后选择向SQL Server 2014的现有实例添加功能".

Don't know if you have the Express version of SQL Server 2014, but I had the same problem and I solved downloading SQL Server 2014 Express Advanced Services, then launching the installer and selecting in the installable features list "Full-text and semantic extractions" under "Instance features", then "Add features to an existing instance of SQL Server 2014".

参考(对于SQL Server 2012，但在我的2014上有效):

Reference (for SQL Server 2012, but it worked on my 2014): msdn Blog

这篇关于如何在SQL Server 2014中启用/安装全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！