Full-Text Search is disabled

I recently upgraded one of my SQL Server 2014 instance to SQL Server 2017 and applied CU5. Very recently I installed Full Text Feature and instance is enabled for Full Text.

Database is enabled  for Full Text. Now when I am trying to create Full-Text Index from SSMS on one of my table , Full-Text Index  option is disabled.

select serverproperty('IsFullTextInstalled')

retun 1

use AdventureWorks2012
EXEC sp_fulltext_database 'enable'

Even I am able to create the full text CATALOG   and index using T-SQL, but the Index is not populating. I spent quite some time reading the logs and searching through the windows event logs hopping to see some errors.

As there is no way to figure out, if there is a difference in feature version. I though to re-run the CU5 for SQL Server 2017 and upgraded the Full Text feature. Post upgrade Full-Text Index  is enabled.





Leave a Reply

Your email address will not be published.