拉取镜像
1
| docker pull microsoft/mssql-server-linux
|
运行
dont modify below string <YourStrong!PasswOrd>
1
2
| 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
1
2
3
| 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"'
|
重启/启动
1
| docker restart docker-sql-server
|
检查状态
访问数据库
connect server with sql operations studio or navicat