How to Install Microsoft SQL on Linux
In this video, we demonstrate how to do install Microsoft SQL on Linux, specifically versions of CentOS 7 and Ubuntu 18.04.
Commands used:
CentOS 7
[root@centos ~]# yum update -y
[root@centos ~]# curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config...
[root@centos ~]# yum install -y mssql-server
[root@centos ~]# /opt/mssql/bin/mssql-conf setup
2) Developer (free, no production use rights)
[root@centos ~]# systemctl status mssql-server
[root@centos ~]# curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config...
[root@centos ~]# yum install -y mssql-tools unixODBC-devel
[root@centos ~]# echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >>
~/.bash_profile
[root@centos ~]# echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
[root@centos ~]# source ~/.bashrc
[root@centos ~]# sqlcmd -S localhost -U SA
Ubuntu 18.04 LTS
root@ubuntu1604:~# apt-get update -y
root@ubuntu1604:~# wget qO https://packages.microsoft.com/keys/m... | apt-key add
root@ubuntu1604:~# add-apt-repository "$(wget -qO https://packages.microsoft.com/config...)"
root@ubuntu1604:~# apt-get install -y apt-transport-https
root@ubuntu1604:~# apt-get update -y
root@ubuntu1604:~# apt-get install -y mssql-server
root@ubuntu1604:~# /opt/mssql/bin/mssql-conf setup
2) Developer (free, no production use rights)
root@ubuntu1604:~# systemctl status mssql-server --no-pager
root@ubuntu1604:~# apt-get install -y ufw
root@ubuntu1604:~# ufw enable
root@ubuntu1604:~# ufw allow 1433
root@ubuntu1604:~# curl https://packages.microsoft.com/keys/m... | apt-key add -
root@ubuntu1604:~# curl https://packages.microsoft.com/config... | tee /etc/apt/sources.list.d/msprod.list
root@ubuntu1604:~# apt-get update -y
root@ubuntu1604:~# apt-get install -y mssql-tools unixodbc-dev
root@ubuntu1604:~# echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
root@ubuntu1604:~# echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
root@ubuntu1604:~# source ~/.bashrc
root@ubuntu1604:~# sqlcmd -S localhost -U SA
The related article for this article can be found here: https://www.liquidweb.com/kb/how-to-i...
For more information about this and other topics, visit us at https://www.liquidweb.com/kb/ or for more information about our products, visit: https://www.liquidweb.com/products/ to learn more about our current specials!
Video by: Justin Palmer
Watch video How to Install Microsoft SQL on Linux online without registration, duration hours minute second in high quality. This video was added by user Liquid Web 26 October 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,250 once and liked it 24 people.