This is a minimal Docker image for Microsoft SQL Server 2019, built over Debian Old Stable Slim.
https://hub.docker.com/r/igeclouds/mysqlserver
Because I personnaly use it, and if it is useful to someone, why not share it?
For example : sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong@Passw0rd>" -p 1433:1433 --name sql1 -h sql1 -d igeclouds/mssqlserver
Parameter | Description |
---|---|
-e "ACCEPT_EULA=Y" | Set the ACCEPT_EULA variable to any value to confirm your acceptance of the End-User Licensing Agreement. Required setting for the SQL Server image. |
-e "SA_PASSWORD=YourStrong@Passw0rd" | Specify your own strong password that is at least eight characters and meets the SQL Server password requirements. Required setting for the SQL Server image. |
-p 1433:1433 | Map a TCP port on the host environment (first value) with a TCP port in the container (second value). In this example, SQL Server is listening on TCP 1433 in the container and this is exposed to the port, 1433, on the host. |
--name sql1 | Specify a custom name for the container rather than a randomly generated one. If you run more than one container, you cannot reuse this same name. |
-h sql1 | Used to explicitly set the container hostname. If you don't specify the hostname, it defaults to the container ID, which is a randomly generated system GUID. |
abesnier/mssql | My SQL Server 2019 container image. |
(shamelessly copied from MS Instructions)
Have a look at the sample docker-compose.yml
docker exec -it mssql sqlcmd -U SA -P <YourStrongPassword> -Q "SELECT @@VERSION"
Output should look like this:
--------------------------------------------------------------------
--------------------------------------------------------------------
Microsoft SQL Server 2019 (RTM-CU22) (KB5027702) - 15.0.4322.2 (X64)
Jul 27 2023 18:11:00
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Linux (Debian GNU/Linux 11 (bullseye)) <X64>
(1 rows affected)
This Docker image installs the Developper edition of MS Sql Server 2019.
SQL Server licensed is the same for Linux and Windows. For more information about SQL Server licensing and pricing, see How to license SQL Server.