MS SQL Server is going to be available on Linux platforms

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.

sudo su

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.

exit

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

or

# iptables -A INPUT -p tcp --dport 1433 -j ACCEPT
# iptables-save > /etc/sysconfig/iptables

I will post more articles upon testing this further…

Leave a Reply

Your email address will not be published. Required fields are marked *