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/sqlservr
Create the image
Save this snippet into a Dockerfile and create an image with a tag of your choice. For example:
1docker 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.
1docker run --name mssql -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=YourPass123#" -e "MSSQL_AGENT_ENABLED=true" -p 1401:1433 -d benjaminabt/mssql-fts:2017-ubuntu
In 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
May 02, 2019 - 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 …
Aug 30, 2018 - 4 min read
Run ASP.NET Core with .NET Framework in a Docker Container
Sometimes you still have the requirement that the .NET Framework is needed - but you still want to use ASP.NET Core and Docker.
Jul 28, 2018 - 2 min read
Run ActiveMQ in Docker on your Synology
If you have a Synology with an x86 CPU it is very easy to run Docker Containers on your Synology. If you have a ARM-based Synology systems, …
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.