How to identify sql server version for target Podman or Docker Container Imager

29 January,2021 by Jack Vamvas

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


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.

Working...

Post a comment on How to identify sql server version for target Podman or Docker Container Imager


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer