A Microsoft não fornece o servidor mssql oficial para 18.04 ainda (05-12-2018), para testar apenas você pode tentar esta solução alternativa (de mim).
Workaround for installing Microsoft's SQL Server (mssql) on Ubuntu
WARNING: FOR TESTING ONLY
Download latest package mssql-server_14.0.3025.34-3_amd64.deb from https://packages.microsoft.com/ubuntu/16.04/mssql-server-2017/pool/main/m/mssql-server/
Change directories
cd ${HOME} && mkdir -p tmp/mssql/newpkg/DEBIAN/ && cd tmp/mssql wget https://packages.microsoft.com/ubuntu/16.04/mssql-server-2017/pool/main/m/mssql-server/mssql-server_14.0.3025.34-3_amd64.deb
Unpack
dpkg-deb -x mssql-server_14.0.3025.34-3_amd64.deb newpkg/ dpkg-deb -e mssql-server_14.0.3025.34-3_amd64.deb newpkg/DEBIAN/
Modify
sed -i -e 's#openssl (<= 1.1.0)#openssl (<= 1.1.1)#g' newpkg/DEBIAN/control cat newpkg/DEBIAN/control | grep openssl
Repackage
dpkg-deb -b newpkg/ 18.04-mssql-server_14.0.3025.34-3_amd64_.deb
First try, this will fail for dependencies
sudo dpkg -i 18.04-mssql-server_14.0.3025.34-3_amd64_.deb
Install dependencies
sudo apt install -f
Second try, this should be done
sudo dpkg -i 18.04-mssql-server_14.0.3025.34-3_amd64_.deb
Follow the messages from package to setup the mssql server
Troubleshooting
The database directory
/var/opt/mssql
should not put on zfs dataset, if you are using zfs, create a zvol and format as ext4/xfs for it.Error: "Dump collecting thread [4404] hit exception [6]. Exiting."
Fix:sudo usermod -a -G disk mssql
Reason: mssql user can not access zvol.References:
- https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017
- https://gist.github.com/shamil/3140558