将组件添加到现有的sql server 2012 express版本 [英] Add component to an existing sql server 2012 express edition

问题描述

如何将组件添加到现有的sql server 2012 Express版本。

我想要的是添加全文搜索，因为在运行此查询时：

Hi,

How can I add a component to an existing sql server 2012 express edition.
What I want is to add a full-text search because while running this query :

CREATE FULLTEXT CATALOG x_catalog;

它已创建，但现在正在运行索引的全文此查询

it is created but now while running a full-text indexed with this query

CREATE FULLTEXT INDEX ON dbo.x(x LANGUAGE 1033)
KEY INDEX uq_x ON x_catalog;

我收到此错误：

I am getting this error:

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

现在运行此查询时

Now while running this query

SELECT fulltextserviceproperty('IsFulltextInstalled');

我得到了一个因此结果为零1，这意味着sql server不运行全文搜索。



有关如何将此组件添加到现有sql server 2012 Express的请联系我还需要重新安装sql server吗？

我在google上做了很多搜索，但我得不到正确答案。

I am getting a zero as the result not 1, this means sql server doesn't run a full-text search.

Please can someone help on how can I add this components to an existing sql server 2012 Express edition or do I need to re-install again sql server?
I have made a lot of search in google but I am not getting the right answer.

推荐答案

您好，



您需要添加此组件。以下是如何操作：

1.确保您拥有正确的安装媒体。您需要带有高级服务的SQL Server Express 。如果您没有，可以从这里下载：

SQL Server Express [ ^ ]

按下载SQL Server 2012 Express按钮，然后选择带有高级服务版本的SQL Server Express。

2。启动安装媒体。单击左侧区域中的安装，然后单击新建SQL Server独立安装或向现有安装添加功能。

3.关注wizzard，在某些时候你应该看到安装类型有两个选项。选择向现有SQL Server 2012实例添加功能。如果您有多个实例，请选择正确的实例。

4.然后您应该看到特征选择。勾选搜索全文和语义提取复选框并继续安装。

5.安装完成后，打开 SQL Server配置管理器 。导航到左侧区域中的 SQL Server服务，然后 SQL全文过滤器守护程序启动器。确保它的状态是正在运行，你对设置感到满意。



就是这样。

Hi,

You need to add this component. Here is how to do it:
1. Make sure you have the right installation media. You need SQL Server Express with Advanced Services. If you don't have it, you can download it from here:
SQL Server Express[^]
Press "Download SQL Server 2012 Express" button and then select SQL Server Express with Advanced Services version.
2. Launch your installation media. Click installation in the left area and then click New SQL Server stand-alone installation or add features to an existing installation.
3. Follow the wizzard and at some point you should see Installation Type with two options. Select Add features to an existing instance of SQL Server 2012. If you have more than one instance, select the right one.
4. Then you should see Feature Selection. Put a tick in Full-Text and Semantic Extractions for Search check box and continue installation.
5. After installation, open SQL Server Configuration Manager. Navigate to SQL Server Services in the left area and then SQL Full-text Filter Daemon Launcher. Make sure its state is "Running" and you're happy with settings.

That's it.

这篇关于将组件添加到现有的sql server 2012 express版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！