Docker - MSSQL 2017
Nov 5, 2018
Microsoft has released MSSQL for Linux and they even released a docker container for it. This makes things pretty straight forward to get running.
There are some issues with ZFS datasets because ZFS does not support O_DIRECT. There’s a hack to get it working but it did not for me. It works fine with ext4 though.
- Download the container.
docker pull mcr.microsoft.com/mssql/server:2017-GA-ubuntu
- Configure the systemd server. Change your SA password and the persistent database path (mine is
/mnt/db)./etc/systemd/system/mssql.service
Use a Windows PC to access the database using SQL Server Management Studio.