How to view SQL Server logging on Linux

Question: How can I view SQL Server Logging on Linux ? Answer: SQL Server on Windows - logs details into SQL Server Error logs and Application Logs. Windows event viewer details are available in the Windows Event Logs via the event viewer or Powershell Get-EventLog 1) SQL Server logs details in the SQL Server error log file and the Linux log usually , /var/opt/mssql/log/ 2) Use the journalctl command --show all the log messages since last reboot journalctl -b --list by boot number, step 1 generate list of boot numbers. Use the index number (the first column) from command 1... Read more →

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 →