How to add full-text search to SQL Server Express 2019 installation

Question

I have a local installation of Microsoft SQL Server Express 2019 and just hit the following error:

Full-Text Search is not installed, or a full-text component cannot be loaded.

So, my understanding is the SQL Server Express supports full-text search, but I need to add components.

According to one article I found, there is a New SQL Server stand-alone installation or add features to an existing installation option in SQL Server Express 2016. But I don't have this option in SQL Server Installation Center.

Can anyone tell me how to add full-text support to my installation?

UPDATE:

It appears that, while SQL Server Express 2019 does not support full-text search, SQL Server Express 2019 with Advanced Services does. So I guess my question is: how do I install Advanced Services?

Answer 1

Use this official download of the Microsoft SQL Server Express web installer. Select "Download Media" and pick the install medium that is right for you.

Download page

Web installer after picking "Download Media"