This article was written in 2019. Versions, tools and recommendations may have changed since then. Newer posts are collected under Docker.
By default, there is currently no Full-Text Search Support in the Docker Images for Microsoft SQL Server 2017 or 2019 by Microsoft. The only option currently available is to create your own Docker Image, which includes Full-Text Search in the form of the MSSQL Agent.
Fortunately, others have already thought about it: the Microsoft MSSQL Docker samples shows a Dockerfile that provides full-text support.
1## Source: https://github.com/Microsoft/mssql-docker/blob/master/linux/preview/examples/mssql-agent-fts-ha-tools/Dockerfile
2
3# mssql-agent-fts-ha-tools
4# Maintainers: Microsoft Corporation (twright-msft on GitHub)
5# GitRepo: https://github.com/Microsoft/mssql-docker
6
7# Base OS layer: Latest Ubuntu LTS
8FROM ubuntu:16.04
9
10# Install prerequistes since it is needed to get repo config for SQL server
11RUN export DEBIAN_FRONTEND=noninteractive && \
12 apt-get update && \
13 apt-get install -yq curl apt-transport-https && \
14 # Get official Microsoft repository configuration
15 curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
16 curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | tee /etc/apt/sources.list.d/mssql-server.list && \
17 apt-get update && \
18 # Install SQL Server from apt
19 apt-get install -y mssql-server && \
20 # Install optional packages
21 apt-get install -y mssql-server-ha && \
22 apt-get install -y mssql-server-fts && \
23 # Cleanup the Dockerfile
24 apt-get clean && \
25 rm -rf /var/lib/apt/lists
26
27# Run SQL Server process
28CMD /opt/mssql/bin/sqlservrCreate the image
Save this snippet into a Dockerfile and create an image with a tag of your choice. For example:
docker build -t benjaminabt/mssql-fts:2017-ubuntu .After a few minutes, depending on how fast your internet and your PC is, your image should be listed under the command docker images.
Run the image
The Docker Container can now be created. It is a best to assign a name directly, so that starting and stopping later is easier.
Make sure to include the additional argument -e "MSSQL_AGENT_ENABLED=true". This also starts the agent that provides full-text support.
docker run --name mssql -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=YourPass123#" -e "MSSQL_AGENT_ENABLED=true" -p 1401:1433 -d benjaminabt/mssql-fts:2017-ubuntuIn this case, the container can be reached via port 1401.
To start the Docker Container just type docker start mssql; to stop it just use docker stop mssql.
Note: on Windows, the command line uses double quotes("). On Linux, single quotes (’) are used.
The MSSQL Server 2017 Docker Container can now be used with Full-Text Search Support :-)
Related articles
- 2 min read
Run MSSQL on Docker for Windows
For some time now, Microsoft has been providing various MSSQL Server versions for Docker - for Linux and for Windows. This means that …
- 10 min read
Distroless, Chiseled or Alpine: Choosing a .NET Base Image
Distroless, Chiseled and Alpine are often compared as three equivalent Linux distributions. They are not. Alpine is a distribution built …
- 15 min read
Stop Using nginx as Your Default Static File Server in Docker
In the week of October 21, 2026, government portals in the Netherlands, Finland and Germany, hospital websites and several large companies …
BEN ABT
Ben is Chief Engineering Officer and Principal Software Engineer at Medialesson.de, with a strong focus on .NET and Microsoft Azure. In his professional role, he designs and builds highly scalable platforms for hybrid and cloud-based scenarios. He also advises companies and C-levels on migrating to the sovereign cloud.
He runs myCSharp.de, the largest and most active German-speaking C# community forum, actively contributes to both his own and external open-source projects and regularly shares his knowledge through his blog, at community events, conferences and as a writer for technical magazines.
Let's Work Together
Looking for an experienced Platform Architect or Engineer for your next project? Whether it's cloud migration, platform modernization or building new solutions from scratch - I'm here to help you succeed.