When installing erwin Web Portal on SQL Server database, get an error:"Missing Database Privileges: Full-Text not enabled, please follow installation instruction documents"How to check Full-Text is installed and enabled on SQL Server on the database?

Solution:

erwin - Agent

You can determine if Full-Text Search is installed by querying the FULLTEXTSERVICEPROPERTY using the following query:

SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

If the query returns 1 then Full-Text Search is enabled. If it returns 0 then Full-Text Search is not enabled and you will need to run SQL Server Installation Center to add the Full-Text Search feature.

You can also go to Control Panel | Services and check if MSSQLFDLauncher is enabled or not.