Skip to content

Latest commit

 

History

History

mssql-server-windows

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
dockerfile
dockerfile
 
 
readme.md
readme.md
 
 
start.ps1
start.ps1
 
 

readme.md

mssql-server-windows

This Dockerfile helps developers to get started using SQL Server vNext in Windows Containers. The file downloads and installs SQL Server vNext with the default setup parameters.

Contents

About this sample
Before you begin
Run this sample
Sample details
Disclaimers
Related links

About this sample

  1. Applies to: SQL Server vNext, Windows Server 2016, Windows 10
  2. Authors: Perry Skountrianos [perrysk-msft]

Before you begin

To run this sample, you need the following prerequisites.

Software prerequisites:

You can run the container with the following command. (Note the you'll need Windows Server 2016 or Windows 10)

docker run -d -p 1433:1433 -v C:/temp/:C:/temp/ -e sa_password=<YOUR SA PASSWORD> -e ACCEPT_EULA=Y -e attach_dbs="<DB-JSON-CONFIG>" microsoft/mssql-server-windows

  • -p HostPort:containerPort is for port-mapping a container network port to a host port.

  • -v HostPath:containerPath is for mounting a folder from the host inside the container.

    This can be used for saving database outside of the container.

  • -it can be used to show the verbose output of the SQL startup script.

    Use this to debug the container in case of issues.

Run this sample

The image provides two environment variables to optionally set:

  • accept_eula: Confirms acceptance of the end user licensing agreement found here

  • sa_password: Sets the sa password and enables the sa login

  • attach_dbs: The configuration for attaching custom DBs (.mdf, .ldf files).

    This should be a JSON string, in the following format (note the use of SINGLE quotes!)

    [
  {
  	'dbName': 'MaxDb',
  	'dbFiles': ['C:\\temp\\maxtest.mdf',
  	'C:\\temp\\maxtest_log.ldf']
  },
  {
  	'dbName': 'PerryDb',
  	'dbFiles': ['C:\\temp\\perrytest.mdf',
  	'C:\\temp\\perrytest_log.ldf']
  }
]

    This is an array of databases, which can have zero to N databases.

    Each consisting of:

    • dbName: The name of the database

    • dbFiles: An array of one or many absolute paths to the .MDF and .LDF files.

      Note: The path has double backslashes for escaping! The path refers to files within the container. So make sure to include them in the image or mount them via -v!

This example shows all parameters in action:

docker run -d -p 1433:1433 -v C:/temp/:C:/temp/ -e sa_password=<YOUR SA PASSWORD> -e ACCEPT_EULA=Y -e attach_dbs="[{'dbName':'SampleDB','dbFiles':['C:\\temp\\sampledb.mdf','C:\\temp\\sampledb_log.
ldf']}]" microsoft/mssql-server-windows

Sample details

The Dockerfile downloads and installs SQL Server 2016 Express with the following default setup parameters that could be changed (if needed) after the image is installed.

  • Collation: SQL_Latin1_General_CP1_CI_AS
  • SQL Instance Name: SQLEXPRESS
  • Root Directory: C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL
  • Language: English (United Stated)

Disclaimers

The code included in this sample is not intended to be a set of best practices on how to build scalable enterprise grade applications. This is beyond the scope of this quick start sample.

Related Links

For more information, see these articles: