docker搭建SQL server

docker搭建SQL server

sudo docker pull mcr.microsoft.com/mssql/server:2022-latest

sudo chmod 777 -R  sqlserver/

sudo docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=pwd" -p 1433:1433 -v /home/application/sqlserver/data:/var/opt/mssql/data -v /home/application/sqlserver/log:/var/opt/mssql/log -v /home/application/sqlserver/secrets:/var/opt/mssql/secrets --restart=always --name sql1 --hostname sql1 -d  mcr.microsoft.com/mssql/server:2022-latest 

如果用navicat链接报错：Client unable to establish connection(10054)
下载个最新的ODBC
https://learn.microsoft.com/zh-cn/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16#download-for-windows