1. 拉取 SQL Server 2017 Linux 容器映像
sudo docker pull mcr.microsoft.com/mssql/server:2017-latest
2.使用 Docker 运行容器映像 : <YourStrong!Passw0rd>-SQL Server 密码
sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong!Passw0rd>" \ -p 1433:1433 --name sql1 \ -d mcr.microsoft.com/mssql/server:2017-latest
3.更改密码
<YourStrong!Passw0rd>-SQL Server 密码
<YourNewStrong!Passw0rd>-SQL Server 新密码
sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \ -S localhost -U SA -P "<YourStrong!Passw0rd>" \ -Q 'ALTER LOGIN SA WITH PASSWORD="<YourNewStrong!Passw0rd>"'
4.进入容器shell 环境
docker exec -it "sql1" bash
5.连接SQL Server
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "<YourNewStrong!Passw0rd>"
启动情况 : docker ps -a
镜像启动 : docker start sql1
镜像停止 : sudo docker stop sql1
移除容器 : docker rm sql1