MS SQL Server is going to be available on Linux platforms
Microsoft has announced the plans to bring MS SQL Server to Linux which is going to be major one. Linux and other linux based platforms are widely used in today’s Cloud which is where this is going to fit.
Satya Nadella’s leadership has made plans to make SQL Server a Leader in Database technology and to expand the SQL Server beyond just Windows platforms and this has surprised all IT World.
The Preview version packages are already available for Red Hat Enterprise Linux 7, CentOS 7, Ubuntu Server 16.04 64 bits etc..
There is a minimum system requirement of the preview version for server to have atleast 3.25 GB of RAM.
Below is step by step method for installation of MS SQL Server Preview on Linux.
Now lets go on to installing SQL Server on Linux (RHEL):
1.Enter Superuser mode in Linux by using below command.
2.Download the Microsoft SQL Server Red Hat repository configuration file by using below command:
curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo
3.Exit superuser mode by using below command.
Now for installing SQL Server, run the following command:
sudo yum install -y mssql-server
After the package installation finished, we have to run mssql-conf setup and follow the prompts. Make sure to specify a strong password for the SA account with minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols.
sudo /opt/mssql/bin/mssql-conf setup
To verify that the service is running, use below command:
systemctl status mssql-server
To allow remote connections to SQL Server, we have to open port on the firewall or IPTables on Linux. The default SQL Server port is TCP 1433.
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload
# iptables -A INPUT -p tcp --dport 1433 -j ACCEPT
# iptables-save > /etc/sysconfig/iptables
I will post more articles upon testing this further…