Install SQL Server Docker Container on Linux and Connect through Client Tools I was surprised by ability to run setup and run SQL Server Docker container. It only takes about 2 commands and 2 Minutes.
1 2 3 4 5 |
$docker pull microsoft/mssql-server-linux $docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password' -p 1433:1433 -d microsoft/mssql-server-linux $docker exec -it 40dd "bash" $/opt/mssql-tools/bin/sqlcmd -S localhost -U SA Password: |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
[root@ip-10-0-0-110 ec2-user]# docker pull microsoft/mssql-server-linux [root@ip-10-0-0-110 ec2-user]# docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password' -p 1433:1433 -d microsoft/mssql-server-linux [root@ip-10-0-0-120 ec2-user]# docker exec -it 40dd "bash" root@40dde973f4a0:/# /opt/mssql-tools/bin/sqlcmd -S localhost -U SA Password: Command History [root@ip-10-0-0-110 ec2-user]# docker pull microsoft/mssql-server-linux Using default tag: latest latest: Pulling from microsoft/mssql-server-linux 4c0c60131530: Pull complete Digest: sha256:604d27fe5d3d9b4434fb1657e9bf4f2c2bf55ea9bd29dc0cb3660d84bc6f56a8 Status: Downloaded newer image for microsoft/mssql-server-linux:latest [root@ip-10-0-0-110 ec2-user]# docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password' -p 1433:1433 -d microsoft/mssql-server-linux 40dde973f4a0cc2af469f9d1c2182403d1e22e28c2a8821e29ce832529965513 [root@ip-10-0-0-120 ec2-user]# docker -it 40dd "bash" flag provided but not defined: -it See 'docker --help'. [root@ip-10-0-0-120 ec2-user]# docker exec -it 40dd "bash" root@40dde973f4a0:/# /opt/mssql-tools/bin/sqlcmd -S localhost -U SA Password: 1> select @@servername; 2> go -------------------------------------------------------------------------------------------------------------------------------- 40dde973f4a0 (1 rows affected) 1> select db_name(); 2> go -------------------------------------------------------------------------------------------------------------------------------- master (1 rows affected) |
Version Info:
1 2 3 4 5 6 7 8 |
select @@version /* Microsoft SQL Server 2017 (CTP2.1) - 14.0.600.250 (X64) May 10 2017 12:21:23 Copyright (C) 2017 Microsoft Corporation. All rights reserved. Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS) */ |
…