Install Full-text in SQL Server

Question

I plan to use full text index (Full-Text) in my SQL Management Server 2014.

I created a catalog with the command:

CREATE FULLTEXT CATALOG [noticiasFullText] WITH ACCENT_SENSITIVITY = OFF

And when I went to create the full text index in my table with the command:

CREATE FULLTEXT INDEX ON Noticias
(titulo LANGUAGE 1046, descricao LANGUAGE 1046)
KEY INDEX idnoticia
ON noticiasFullText
WITH STOPLIST = OFF

Made the following mistake:

Mensagem 7609, Nível 17, Estado 5, Linha 4
A pesquisa de texto completo não está instalada ou não é possível carregar um componente de texto completo.

So I searched how to install Full-text on my SQL Server, but without success. This is a feature that should be downloaded, or is already in my SQL Server and just need to activate it?

How do I use Full-Text in my SQL Server?

Answer 1

This is a feature that should be downloaded, or is already in my SQL Server and just need to activate it?

Full text search (full-text search) is an optional component of the Database Mechanism (database engine) SQL Server. Since SQL Server is already installed, you should then follow the script Add resources to an instance of SQL Server 2014. On the "Feature Selection" page, select the "Full-Text and Semantic Extractions for Search" option, as shown below.

According to the document Features compatible with SQL Server 2014 editions, this feature is available in Enterprise, Business Intelligence, Standard, Web and Express with Advanced Services editions. Aware that Express with Tools and Express editions do not offer this feature.

---

How do I use Full-Text in my SQL Server?

In the document Full text search you find information about using the resource.