Tag: sql server

Categories
Programming Shell Script (BASH) SQL

Install SQL Server 2019 in Ubuntu 20.04 LTS

Learn how to Install SQL Server 2019 in Ubuntu 20.04 LTS. Lets just start straightaway. While it is a straightforward process in Microsoft Windows operating system, it is different in Ubuntu (or Debian based supported distributions).

If you are in a rush and/or are too pro to skip this, I have also provided a Shell script. The shell script can be found HERE! but I recommend reading this post to make sure nothing is skipped and the installation of Microsoft SQL Server 2019 goes smoothly.

codeonion:~$ lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 20.04 LTS
Release:	20.04
Codename:	focal

Lets Begin Installation of Microsoft SQL Server 2019 in Ubuntu 20.04

Install software-properties-common

sudo apt install software-properties-common
sudo apt-get update

Import the public repository GPG keys:

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

Register the Microsoft SQL Server Ubuntu repository for SQL Server 2017:
https://packages.microsoft.com/config/ubuntu/20.04/

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

Install Microsoft SQL Server 2019 in Ubuntu

sudo apt update
sudo apt install mssql-server

We are recommended to run a command

So lets run it
sudo /opt/mssql/bin/mssql-conf setup

Pick your Microsoft SQL Server 2019 Edition

When prompted, accept the license and then set up a PASSWORD

Confirm Microsoft SQL Server 2019 Active Status

systemctl status mssql-server.service

Should show active running database server


Install Microsoft SQL TOOLS mssql-tools

Lets now install mssql-tools. But first!! Acquire the power of Sudo Su!

sudo su

This breaks all the walls and lets you do whatever the crap you want. So be careful :). Now do the following.

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/19.10/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt update 
sudo ACCEPT_EULA=Y apt install mssql-tools unixodbc-dev

Configure PATH for MS SQL binaries

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/19.10/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt update 
sudo ACCEPT_EULA=Y apt install mssql-tools unixodbc-dev

Now connect to your server using

sqlcmd -S 127.0.0.1 -U sa -P <yourpassword>

Shell Script to Install Microsoft SQL Server 2019 in Ubuntu 20.04

Finally, I will be an ass if I didn’t make a shell script of this process so:

First 

sudo su

Then run the following shell script (replace your password at the bottom of the script)

!/bin/bash
lsb_release -a
sudo apt install software-properties-common -y
sudo apt install curl -y
sudo apt-get update
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
systemctl status mssql-server --no-pager
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt-get update
sudo apt-get install mssql-tools unixodbc-dev -y
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sqlcmd -S 127.0.0.1 -U sa -P <YOUR PASSWORD HERE>

Then test the following query

SELECT Name from sys.Databases;
GO

And you will see:

That may be the end of it. Let me know if it helped. Please comment and share if it helped. Lets us know.

Thanks.