How to debug Kerberos and LDAP for SQL Server

Question: I've deployed Container based SQL Servers and set up integrated authentication with Active Directory. There are some issues and I need to explore error messages for some AD failures. How can I generate a log to gather trace statements and responses? Answer: It is possible to gather this information by enabling the SQL Server - SQLPAL - Logging . Part of enabling SQLPAL includes configuring the location for the output log file. By default SQLPAL is turned off. Add following to /var/opt/mssql/logger.ini. If the logger.ini is not present , than create the file in the /var/opt/mssql/ path. If it... Read more →

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

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... Read more →