Full-Text Search is not installed, or a full-text component cannot be loaded.

While working on my previous article about LIKE vs CONTAINS, I tried to create a Full-Text Index on a column and got the below error:

Msg 7609, Level 17, State 5, Line 1

Full-Text Search is not installed, or a full-text component cannot be loaded.

Full-Text Search Is Not Installed error message

The error message indicates that the full text search service is not installed. Hence, I used the SERVERPROPERTY to check if full text search is installed or not. It returned the result “0”, which means full text search is not yet installed.

SELECT SERVERPROPERTY('IsFullTextInstalled')
Full-Text Search Is Not Installed

Solution

So, to fix the problem, I have installed the Full-Text and Semantic Extractions for Search service by running the SQL Server Installation Center.

installing  Full-Text and Semantic Extractions for Search service

After installing Full-Text and Semantic Extractions for Search service and restarting the server, I was able to create the Full-Text Index on the column.

Reference


Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.