SQL Server 2019 on Ubuntu Linux

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

-> Provisioning an Ubuntu Server 18.04 LTS Azure Virtual machine.

Blog91_1
Blog91_2
Blog91_3

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

Blog91_5
Blog91_6
Blog91_7
Blog91_8
Blog91_9

-> 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,

Blog91_10
Blog91_11

-> Below command can be used to import the public repository GPG keys

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
Blog91_12

-> Below command will be used to register the Microsoft SQL Server Ubuntu repository:

sudo add-apt-repository "$(wget -qO- "https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list)"
Blog91_13

-> Below commands will be used to initiate the SQL Server 2019 install,

sudo apt-get update
Blog91_14
sudo apt-get install -y mssql-server
Blog91_15
sudo /opt/mssql/bin/mssql-conf setup
Blog91_16

In Putty, Developer Edition is selected.

Blog91_17

“License terms” should be accepted. SQL Server system administrator password should be provided. This will be the sa password.

Blog91_18
Blog91_19

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

systemctl status mssql-server --no-pager
Blog91_20

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

Blog91_21
Blog91_22

-> 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