29 January,2021 by Tom Collins
Question: I'm setting up different Podman and Docker based Containers for SQL Server. I'd like to know , how can I identify the SQL Server version & build number , if I'm using the mcr.microsoft.com/mssql/server:2019-latest convention, when choosing which image to use? Based on the information it isn't possible to tell the version and build numbers
An example podman command:
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=myPassw0rd" \ -p 1433:1433 --name sql1 \ -d mcr.microsoft.com/mssql/server:2019-latest
Answer: It is possible grab the version number , build and some other information which may be useful
Execute this Podman command. Note: you can also execute this command in Docker , just replace Podman with Docker
podman run -e PAL_PROGRAM_INFO=1 --name sqlver \ -ti mcr.microsoft.com/mssql/server:2019-latest && \ podman rm sqlver
This will give you output similar to the following:
SQL Server 2019 will run as non-root by default. This container is running as user mssql. sqlservr Version 15.0.4083.2 Build ID d5181234401a57a9aa5eb81af2dffbbf9b750124f0065daec40ccce42014973b Build Type release Git Version 0d2b64e0 Built at Tue Dec 08 20:39:50 GMT 2020 PAL Build ID f74ce9a08a6bf5d43be16095a765f910ad1967319df2359a2b9f374b9f73bb79 Build Type release Git Version 39fec36d8 Built at Tue Dec 08 20:37:04 GMT 2020 Packages system.security 6.2.9200.15,unset, system.certificates 6.2.9200.15,unset, secforwarderxplat 15.0.4086.12 sqlservr 15.0.4083.2 system.common 10.0.17134.1246.202005133 system.netfx 4.7.2.461814 system 6.2.9200.15,unset, sqlagent 15.0.4083.2
Read more on Containers
How to find physical path for SQL Server backup on Container
SQL Server Docker and Container Cheat Sheet
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |