Getting error: Missing Database Privileges: Full-Text not enabled, please follow installation ins (4307449)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error: Missing Database Privileges: Full-Text not enabled, please follow installation ins
Description

Getting error: Missing Database Privileges: Full-Text not enabled, please follow installation instruction documents.
Resolution

Description:

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.

erwin - Agent

http://www.sqlservercurry.com/2009/12/how-to-detect-if-full-text-search-is.html

Please also refer to Readme at:

http://www.metaintegration.net/Products/MIMM/MIMMReadme.html#DatabaseOnMicrosoftSQLServer

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title