-> SQL Server 2019 installation will be performed on a Redhat Azure Virtual Machine.
-> Provisioning a Red Hat Enterprise Linux 8 Azure Virtual machine.
-> NIC network security group will be set to None as this is a test instance. Appropriate configuration will be required for production server.
-> 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,
-> 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
-> Below command will be used to install SQL Server,
sudo yum install -y mssql-server
-> After package installation, execute below command to set SA password and slect appropriate edition,
sudo /opt/mssql/bin/mssql-conf setup
-> Below command can be used to check the status of installed SQL Server,
systemctl status mssql-server
-> 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
-> Open SQL Server Management Studio and connect to the Installed SQL Server using Public IP address,
-> All SQL Server configuration can be performed from SQL Server Management Studio.
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.