Skip to content

sql-server-linux-setup-docker.md

Latest commit

 

History

History
70 lines (52 loc) · 2.58 KB

sql-server-linux-setup-docker.md

File metadata and controls

70 lines (52 loc) · 2.58 KB
title Run the SQL Server Docker image on Linux, Mac, or Windows - SQL Server vNext CTP1 | Microsoft Docs
description
author rothja
ms.author jroth
manager jhubbard
ms.date 11/15/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:latest

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

     $ sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=your_password_here" -p 1433:1433 -d microsoft/mssql-server-linux:latest

  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_folder>:/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=your_password_here" -p 1433:1433 -v \<host folder\>:/var/opt/mssql -d private-repo.microsoft.com/mssql-private-preview/mssql- server:latest

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

Next steps

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