SQL Server 2019 on Redhat Linux

-> SQL Server 2019 installation will be performed on a Redhat Azure Virtual Machine.

-> Provisioning a Red Hat Enterprise Linux 8 Azure Virtual machine.

Blog92_1

Blog92_2

Blog92_3

-> NIC network security group will be set to None as this is a test instance. Appropriate configuration will be required for production server.

Blog92_5

Blog92_6

Blog92_7

Blog92_8

-> Install Putty from https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html to login to the provisioned Virtual Machine and start the SQL Server 2019 Install.

-> From Azure portal open the virtual machine provisioned and click on connect. Make sure SSH tab is selected. Public IP address in the SSH tab will be used in the putty session to connect to the provisioned Virtual Machine,

Blog92_9

Blog92_10

-> Below command can be used to download Microsoft SQL Server 2019 Red Hat repository configuration file,

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

Blog92_11

Blog92_12

-> Below command will be used to install SQL Server,

sudo yum install -y mssql-server

Blog92_13

Blog92_14

-> After package installation, execute below command to set SA password and slect appropriate edition,

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

Blog92_15

-> Below command can be used to check the status of installed SQL Server,

systemctl status mssql-server

Blog92_16

-> Use below command to allow remote connections by opening TCP port 1433,

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

Blog92_17

-> Open SQL Server Management Studio and connect to the Installed SQL Server using Public IP address,

Blog92_18

Blog92_19

-> All SQL Server configuration can be performed from SQL Server Management Studio.

 

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s