In order to support optimized text search in Business Central On-prem, the SQL Server instance must have the full-text search feature installed. The version 25 base application requires this feature but it is not installed by default. You need to install Full-text and Semantic Extractions for Search feature in the SQL Server instance.
Verify whether full-text search is installed or not T-SQL SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') AS IsFullTextInstalled; If the above query returns 0 then the full-text search is not installed and if 1 returned it is installed.
SQL Server Management Studio In Object Explorer, right click on the server instance and then select Properties and then select Advanced and If the Default Full-Text Language property is present then full-text search is installed otherwise it is not installed.
Install full-text search and add it as a feature by using the SQL Server Installation Center. You need the access the installation media for your SQL Server version and then run setup.exe to start the SQL Server Installation Center.
Follow the instructions at Add Features to an Instance of SQL Server and when you get to the Feature Selection page, choose Full-text and Semantic Extractions for Search and continue with the installation.
|