Moved from: bobsql.com
I can’t take credit for this post as Dylan added the code and provided the write-up to share with you. All I did was a bit of editing and proof reading, enjoy.
For SQL Server on Linux, there are additional logging capabilities. These can be vital in debugging issues like AD authentication. The internal logs are configured using /var/opt/mssql/logger.ini text file and can be configured to write to standard out or files. For example, the logger.ini below will turn on logging for Kerberos and LDAP errors and write them to /var/opt/mssql/log/security.log.