Installing Full-Text Search for SQL Server - PAS ICS Integrity - 7.3 - Installation & Upgrade - Intergraph

Full-Text and Semantic Extractions for Search (Full-Text Search) in SQL Server lets applications run full-text queries against character-based data in SQL Server tables. Integrity requires installation of this optional feature for your SQL Server environment.

Full-Text Search is an optional component of the SQL Server Database Engine. If you did not select this feature when you installed SQL Server, run SQL Server setup again to add it. This topic gives general steps to install Full-Text Search. For more information, see the Microsoft SQL Server documentation for your version of SQL Server.

To install Full-Text Search in SQL Server:

1. If you want to verify whether Full-Text Search is already installed, issue the following query in SQL Server:

   SELECT FULLTEXTSERVICEPROPERTY ('IsFulltextInstalled')

   If Full-Text Search is installed, the result is 1. If it is not installed, the result is 0.

2. Run SQL Server setup.

3. Click Installation on the left pane.

4. Click New SQL Server stand-alone installation or add features to an existing installation.

5. Provide appropriate responses to the prompts depending on which path you selected.

6. Select Full-Text and Semantic Extractions for Search.

7. Continue to the end of the installation process.

8. After the installation completes, restart the following services:

• SQL Server 20XX Configuration Manager

• SQL Server Services

• SQL Full-text Filter Daemon Launcher