MSSQL in Docker: Difference between revisions
Brian Wilson (talk | contribs) Created page with "Set up Docker See https://hub.docker.com/r/microsoft/mssql-server-linux/ Then, docker pull microsoft/mssql-server-linux:latest docker run -e 'ACCEPT_EULA=Y' -e 'SA_PA..." |
Brian Wilson (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
First set up [[Docker]], then pull the SQL Server container, then run it. | |||
See https://hub.docker.com/r/microsoft/mssql-server-linux/ | 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 pull microsoft/mssql-server-linux:latest | ||
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD= | 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 == | == Management == |
Revision as of 22:26, 14 June 2017
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.