Skip to content

sql-server-linux-setup-docker.md

Latest commit

 

History

History
82 lines (62 loc) · 2.75 KB

sql-server-linux-setup-docker.md

File metadata and controls

82 lines (62 loc) · 2.75 KB
title Run the SQL Server Docker image on Linux, Mac, or Windows - SQL Server vNext | Microsoft Docs
description
author rothja
ms.author jroth
manager jhubbard
ms.date 11/16/2016
ms.topic article
ms.prod sql-linux
ms.technology database-engine
ms.assetid 82737f18-f5d6-4dce-a255-688889fdde69

Run the SQL Server Docker image on Linux, Mac, or Windows

This topic explains how to pull and run the mssql-server Docker image. This image can be used with the Docker Engine 1.8+ on Linux or on Docker for Mac/Windows.

Requirements for Docker

  • Docker Engine 1.8+ on any supported Linux distribution or Docker for Mac/Windows.
  • Minimum of 4 GB of disk space
  • Minimum of 4 GB of RAM

Important

The default on Docker for Mac and Docker for Windows is 2 GB for the Moby VM, so you will need to change it to 4 GB. The following sections explain how.

Docker for Mac

  1. Click on the Docker logo on the top status bar.
  2. Select Preferences.
  3. Move the memory indicator to 4GB or more.
  4. Click the restart button at the button of the screen.

For Windows users:

  1. Right-click on the Docker icon from the task bar.
  2. Click Settings under that menu.
  3. Click on the Advanced Tab.
  4. Move the memory indicator to 4GB or more.
  5. Click the Apply button.

Pull and run the Docker image

  1. Pull the Docker image from Docker Hub.

    sudo docker pull microsoft/mssql-server-linux

    [!TIP] If you using Docker for Windows, remove the word sudo from the command-line in this step and step three.

  2. To run the Docker image, you can use the following commands:

    docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 -d microsoft/mssql-server-linux

  3. To persist the data generated from your Docker container, you must map volume to the host machine. To do that, use the run command with the -v <host directory>:/var/opt/mssql flag. This will allow the data to be restored between container executions.

    sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 -v <host directory>:/var/opt/mssql -d microsoft/mssql-server-linux

    [!NOTE] The ACCEPT_EULA and SA_PASSWORD environment variables are required to run the image.

    [!IMPORTANT] Volume mapping for Docker-machine on Mac with the SQL Server on Linux image is not supported at this time.

Next steps

After installing SQL Server on Linux, next see how to connect to the server and run basic Transact-SQL queries.