How to install MSSQL Server on CentOS and RHEL

How to install MSSQL Server on CentOS and RHEL

This post helps you to install MSSQL Server on CentOS and RHEL. The supported filesystems are XFS and Ext4. Also, please note that you need to enable the port 1433 on your server firewall.

The MSSQL server needs 4GB RAM to work properly on Linux platform.

Please check the installation steps below:

Microsoft is already providing the repo for installing MSSQL.

 
cd /etc/yum.repos.d/
wget https://packages.microsoft.com/config/rhel/7/mssql-server.repo
wget https://packages.microsoft.com/config/rhel/7/prod.repo
yum install mssql-server mssql-tools

Once the installation gets completed, configure Microsoft SQL Server using the following command:

 
/opt/mssql/bin/sqlservr-setup

Just accept the license terms and provide the desired administrator password. Then you need to start the MSSQL service.

 
systemctl start mssql-server

Run the following command to enable MSSQL service once the system boots

 
systemctl enable mssql-server

Please enable the port 1433 on your server firewall.

 
firewall-cmd --permanent --zone=public --add-port=1433/tcp
firewall-cmd --reload

That’s it!

If you like this post and wish to receive more articles from us, please like our FB page: Grepitout

Your suggestions and feedbacks will encourage us and help to improve further, please feel free to write your comments.

For more details on our services, please drop us an E-mail at info@grepitout.com