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 go EXEC sp_fulltext_database 'enable' go
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.