MSSQL in Docker

From Wildsong
Revision as of 22:26, 14 June 2017 by Brian Wilson (talk | contribs)
Jump to navigationJump to search

First set up Docker, then pull the SQL Server container, then run it.

See https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker and https://hub.docker.com/r/microsoft/mssql-server-linux/

Microsoft blog posting: https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/sql-server-2017-on-linux-surpasses-1-million-docker-pulls-as-the-next-preview-version-rolls-out/

My commands were 

docker pull microsoft/mssql-server-linux:latest
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=strong password' -p 1433:1433 -d microsoft/mssql-server-linux

If your server fails to start re-run it without the daemonize (-d) option; in my case I needed a more complicated password.

Data storage probably needs to be loaded from a volume instead of living inside the container.

Management

You still need a Windows desktop to manage the server, but you download SQL Server Management Studio for free from here.

Of course you have to make sure port 1433 on the server instance is accessible from the desktop. I suggest setting up a VPN tunnel.

Retrieved from "https://wiki.wildsong.biz//index.php?title=MSSQL_in_Docker&oldid=10335"