Docker run MSSQL Server Linux

2018.11.14

2023.02.09

123 words 1 min

拉取镜像

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`

检查状态

1	`docker ps -a`

访问数据库

connect server with sql operations studio or navicat

Author: qomg

Link: http://qomg.github.io/2018/11/14/docker-run-mssql-server-linux/

License: 本博客所有文章除特别声明外，均采用许可协议 CC-BY-NC-4.0 转载请注明出处！