Install MSSQL to CentOS 7

ยท
1 min read
centos
#mssql #centos #database

Install a MS SQL Express to CentOS 7.

Just to make sure:

Terminal window
sudo yum update

Get the YUM package:

Terminal window
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

Install MS SQL:

Terminal window
sudo yum install -y mssql-server

Setup server:

Terminal window
sudo /opt/mssql/bin/mssql-conf setup

Open network firewall for 1433 (default port for MSSQL) so that it could be accessed from other machine.

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

Done.

SOURCE