skip to content
Posts · November 2018

Docker run MSSQL Server Linux

By horace-su·14 November 2018 ·1 min read

拉取镜像

Terminal window
docker pull microsoft/mssql-server-linux

运行

dont modify below string <YourStrong!PasswOrd>

Terminal window
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!PasswOrd>' \
-p 1433:1433 –name docker-sql-server -d microsoft/mssql-server-linux

修改密码

you should replace YourNewStrong!PasswOrd with your password

Terminal window
docker exec -it docker-sql-server /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P '<YourStrong!PasswOrd>' \
-Q 'ALTER LOGIN SA WITH PASSWORD="YourNewStrong!PasswOrd"'

重启/启动

Terminal window
docker restart docker-sql-server

检查状态

Terminal window
docker ps -a

访问数据库

connect server with sql operations studio or navicat