Table of Contents

Install Full-Text and Semantic Extractions for Search

To make on page searches in Business Cnetral faster Microsoft implemented full-text search in Business Central v25. It is an obligatory feature to be installed in Sql Server for Business Central v25 to be able to install.

To check if the feature is installed open Sql Server Management Studio and connect to the Sql Server database engine. Executie this query/command: SELECT SERVERPROPERTY('IsFullTextInstalled');
If it is true then the sql server is prepared for Business Central v25

If it is not do the folowing to install the feature (be aware that the action below might initiate a restart of sql server):

  1. Logon to the server having Sql Server installed.

  2. Search for SQL Server 2022 (or 2019) Installation Center in the Start Menu and start it up.

  3. In the Sql Server Installation Center go to Installaton in the navigation pane.

  4. Click New SQL Server standalone installation or add features to an existing installation

  5. In the SQL Server Setup application which should now be started Click next untill the navigation pane is at Installation Type

  6. Choose Add features to an existing instance of SQL Server and click next.

  7. In the Feature Selection select Full-Text and Semantic Extractions for Search and click next as often as needed for the feature to get installed.