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](https://www.mytecbits.com/wp-content/uploads/SQL-Full-Text-Search-Is-Not-Installed-Error-776x417.png)
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](https://www.mytecbits.com/wp-content/uploads/SQL-Full-Text-Search-Is-Not-Installed-776x367.png)
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](https://www.mytecbits.com/wp-content/uploads/SQL-Full-Text-Search-Installation.png)
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.