MSSQL via Docker on Linux Kernel 6.7

The short answer is “Nope” (as of March 2024). I tried to get a project running on Arch with Kernel 6.7 and was getting errors like:

2024-02-29 17:05:31 Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'sa'..
2024-02-29 17:05:31 Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2749.
2024-02-29 17:05:31 Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

I couldn’t connect to it from database management tools or from my web project. After hours of googling, I finally found a hint that it was due to an incompatibility with Linux Kernel 6.7, which I happened to be on.

I downgraded to kernel 6.6 by running
sudo pacman -S linux-lts
and then rebooting. On the way back up, kernel 6.6 was the default. I didn’t do anything special to make that happen.

After rebooting I could start and connect to my MSSQL docker container without issue.