Skip to content

Instantly share code, notes, and snippets.

@olimorris
Last active May 31, 2024 16:23
Show Gist options
  • Save olimorris/86cdad73255e5a63e05aa56362ace5ae to your computer and use it in GitHub Desktop.
Save olimorris/86cdad73255e5a63e05aa56362ace5ae to your computer and use it in GitHub Desktop.
Use Docker to install MS-SQL Server 2017 with Full Text Search and MS-SQL Tools
# mssql-agent-fts-ha-tools
# Maintainers: Microsoft Corporation (twright-msft on GitHub)
# GitRepo: https://github.com/Microsoft/mssql-docker
# Base OS layer: Latest Ubuntu LTS
FROM ubuntu:16.04
# Install curl since it is needed to get repo config
# Get official Microsoft repository configuration
RUN export DEBIAN_FRONTEND=noninteractive && \
apt-get update && \
apt-get install -y curl && \
apt-get install apt-transport-https && \
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | tee /etc/apt/sources.list.d/mssql-server.list && \
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list && \
apt-get update
# Install SQL Server which a prerequisite for the optional packages below.
RUN apt-get install -y mssql-server
# Install optional packages. Comment out the ones you don't need
RUN apt-get install -y mssql-server-agent
RUN apt-get install -y mssql-server-ha
RUN apt-get install -y mssql-server-fts
RUN apt-get install -y msodbcsql mssql-tools
# Fix locale issues Sql Server Tools
RUN apt-get -y install locales
RUN locale-gen en_US.UTF-8
RUN update-locale LANG=en_US.UTF-8
# Run SQL Server process
CMD /opt/mssql/bin/sqlservr
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment