How to setup FTS component in MSSQL

Owned by Former user (Deleted)
Last updated: Aug 26, 2020
1 min read

Full-Text Search in SQL Server component and run full-text queries against character-based data in SQL Server tables.

Full-Text Search is an optional component of the SQL Server Database Engine. If you didn't select Full-Text Search when you installed SQL Server, run SQL Server Setup again to add it.

More information available on https://docs.microsoft.com/en-us/sql/relational-databases/search/full-text-search?view=sql-server-2017

How to add FTS feature to an Instance

Following document provides a step-by-step procedure for adding features to an instance of SQL Server.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/add-features-to-an-instance-of-sql-server-setup?view=sql-server-2017

Full-text search component can be selected from the available features list, when adding new features to the existing MSSQL server edition. 

Availability of the Full-text search component depends on the SQL server edition (see the table below).

Features Supported by the SQL Server Editions 

VersionAvailable Features
SQL Server  2014https://docs.microsoft.com/en-us/sql/2014/getting-started/features-supported-by-the-editions-of-sql-server-2014?view=sql-server-2017
SQL Server  2016https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017
SQL Server  2017https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017