mssql

https://hub.docker.com/r/microsoft/mssql-server

https://blog.csdn.net/tangdou369098655/article/details/142709867

1.2 创建数据目录

bash
mkdir -p /opt/mssql
chmod 777 /opt/mssql  # 确保容器有写入权限

2025-latest (SQL Server 2025 Preview)

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

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

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

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

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=密码" -p 1433:1433 -v /opt/mssql:/var/opt/mssql -d mcr.microsoft.com/mssql/server:2022-latest

实际账号

https://doc.rg1008.com/docs/rgacount/rgacount-1gt0uajiv0hc0

How to use this image
You can get started with SQL Server 2025 Preview on Ubuntu 22.04 which is currently in preview. To deploy a container with SQL Server 2025 Preview based on Ubuntu 22.04, use the following command:

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<password>" -e "MSSQL_PID=Evaluation" -p 1433:1433  --name sqlpreview --hostname sqlpreview -d mcr.microsoft.com/mssql/server:2025-latest

Start a mssql-server instance for SQL Server 2022 (16.x). These images are based on Ubuntu 22.04, and are fully supported for production workloads.

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<password>" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

Start a mssql-server instance using a CU tag. In this example, we use CU 16 for SQL Server 2022.

Important: If you use PowerShell on Windows to run these commands, use double quotes instead of single quotes.

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<password>" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-CU16-ubuntu-22.04

Start a mssql-server instance using the latest update for SQL Server 2022:

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<password>" -p 1433:1433 -v /opt/mssql:/var/opt/mssql -d mcr.microsoft.com/mssql/server:2022-latest

Start a mssql-server instance running as SQL Server Express edition:

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<password>" -e "MSSQL_PID=Express" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest 
Connect to Microsoft SQL Server

You can connect to the SQL Server instance using the sqlcmd tool inside of the container, with the following command on the host:

docker exec -it <container_id|container_name> /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P <password>