Full-Text not installed on sqlserver 2017 Express

Copper Contributor

Microsoft claims that SQLServer Express provides full-text capabilities. I used the following link to install SQLServer (I ran as 'Administrator'):

https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

The link states:

SQL Server 2017 Express with Advanced Services. Get more features with your Express edition, including database engine, reporting services, and full text search. Download for free when you join Visual Studios Dev Essentials. I also joined Visual Studios Dev Essentials. 

After the install, when I open SQLServer Management Studio, and run the following query on the instance:

my email address is info@globalitsolutionscorp.com

Help!!!

SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
The response is '0' - which means that full-text is not installed.
 
Incidentally, when I did the install (I created a new instance), I checked all of the boxes on the FileStream tab.
 
help!!!!
2 Replies
incidentally, in my post above, when I say full-text, I mean full-text search

Hi!

I had the same issue when downloaded install first time, because it was not advanced version of sql express.

Did you download advanced version? See screenshot below - Download dropdown has two options. Did you select correct version?

 

adv.png