DX EXPERT

1- Prerequisites

MSSQL Server 2019 require python2 and openssl10 

sudo yum install python2
sudo yum install compat-openssl10
sudo alternatives --config python

Download the Microsoft SQL Server 2019 Red Hat repository configuration file for RHEL8:

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

2- SQL server installation

Run the following commands to install SQL Server:

sudo yum install -y mssql-server

3- SQL Server setup

run below command to configure SQL server edition and select the SA strong password

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

4- verify that the service is running

systemctl status mssql-server

5- Firewall Configuration

to allow remote connection the default SQL Server port is TCP 1433

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

by configuring the firewall the Sql server up and running and can connect remotely from windows client to the server

Tags: Sql server, sql server installation, sql server on linux