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.
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')
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.
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
- More about full-text index at Microsoft Docs.