Linux部署SQLServer

Docker部署SQL Server

docker run -d -p 1433:1433

–restart=always

–name mssql \

–hostname szbsqlserver

-e “ACCEPT_EULA=Y”

-e “SA_PASSWORD=p@ssw0rd”

-e “MSSQL_PID=HMWJ3-KY3J2-NMVD7-KG4JR-X2G8G”

-v /data/mssql:/var/opt/mssql

mcr.microsoft.com/mssql/server:latest

SQL Server需修改/etc/hosts、/etc/hostname

Linux初始化SQL Server

/opt/mssql/bin/mssql-conf setup

设置启动SQL Server代理

/opt/mssql/bin/mssql-conf set sqlagent.enabled true

systemctl restart mssql-server