The installation itself is not too bad. It is pretty straightforward.
\nThis process worked well on Ubuntu 18.x installing Microsoft SQL 2017 and 2019. The details in this post are for the 2017 version. The only thing that is different is the repository configuration, and in particular what you download configure the repository to support installing 2019.<\/p>\n
Download and add the Microsoft public repository GPG key:<\/p>\n
wget -qO- https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add –<\/p><\/blockquote>\n
Add the Micorosft apt repository:<\/p>\n
sudo add-apt-repository “$(wget -qO- https:\/\/packages.microsoft.com\/config\/ubuntu\/18.04\/mssql-server-2017.list)”<\/p><\/blockquote>\n
Update repository mirror list:<\/p>\n
sudo apt-get update<\/p><\/blockquote>\n
Install MSSQL 2017:<\/p>\n
sudo apt-get install -y mssql-server<\/p><\/blockquote>\n
Run the MSSQL setup:<\/p>\n
sudo \/opt\/mssql\/bin\/mssql-conf setup<\/p><\/blockquote>\n
The setup will ask just a couple questions. One is which version you want to run. I installed the Developer version. The second this is to accept the license agreement.<\/p>\n
Check MSSQL status to verify it is running:<\/p>\n
systemctl status mssql-server<\/p><\/blockquote>\n
Add the MSSQL tools repository:<\/p>\n
curl https:\/\/packages.microsoft.com\/config\/ubuntu\/18.04\/prod.list | tee \/etc\/apt\/sources.list.d\/msprod.list<\/p><\/blockquote>\n
Update repository mirror list:<\/p>\n
sudo apt-get update<\/p><\/blockquote>\n
Install MSSQL 2017 tools:<\/p>\n
sudo apt-get install mssql-tools unixodbc-dev<\/p><\/blockquote>\n
Add tools directory to account path:<\/p>\n
echo ‘export PATH=”$PATH:\/opt\/mssql-tools\/bin”‘ >> ~\/.bash_profile<\/p><\/blockquote>\n
Add tools directory to account path for non-interactive execution:<\/p>\n
echo ‘export PATH=”$PATH:\/opt\/mssql-tools\/bin”‘ >> ~\/.bashrc
\nsource ~\/.bashrc<\/p><\/blockquote>\nConnect to MSSQL via command line:<\/p>\n
sqlcmd -S localhost -U SA -P ‘
‘<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":" The installation itself is not too bad. It is pretty straightforward. This process worked well on Ubuntu 18.x installing Microsoft SQL 2017 and 2019. The details in this post are for the 2017 version. The only thing that is different is the repository configuration, and in particular what you download configure the repository to support [&hellip<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[48,218,132],"class_list":["post-1860","post","type-post","status-publish","format-standard","hentry","category-documentation","tag-linux","tag-mssql","tag-ubuntu"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/1860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1860"}],"version-history":[{"count":3,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/1860\/revisions"}],"predecessor-version":[{"id":1864,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/1860\/revisions\/1864"}],"wp:attachment":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}