Forum Discussion

will moore's avatar
will moore
Copper Contributor
Mar 16, 2018

Full-Text not installed on sqlserver 2017 Express

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

  • null null's avatar
    null null
    Copper Contributor
    Jul 08, 2018

    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?

     

  • will moore's avatar
    will moore
    Copper Contributor
    Mar 16, 2018
    incidentally, in my post above, when I say full-text, I mean full-text search

Resources