How to install SQL Server 2019 on Ubuntu 20.04 LTS and connect from SQL Server Management studio

Installation guidance for SQL Server on Linux.
In this video we are going to see how to install microsoft sql server 2019 on Ubuntu 20.04 LTS Focal fossa.
Make sure that you have Internet connection to download the dependent debian packages from ubuntu repositories which is used by sql server 2019.

Download SQL Server 2019, ODBC drivers, Unix ODBC Drivers, MS-SQL Tools from below links.

Install sqlcmd and bcp the SQL Server command-line tools on Linux
The mssql-tools package contains:

sqlcmd: Command-line query utility.
bcp: Bulk import-export utility.

We will be installing SQL Server 2019 Developer Edition on this video, which is full featured and free to use for development.

How to start/stop sql server service on Ubuntu Linux:

How to Unblock SQL Server ports on firewall or Allow Ports 1431,1433,1434 Ubuntu Linux for SQL Server

ufw allow 1431
ufw allow 1433
ufw allow 1434

#sqlserveronlinux #sqlserverubuntu #sqlserver2019

[arielcarambula]

Hi, Could you provide the commands ? Thanks

[udankatab]

it would be nice if you had provided with link to download those servers.

[asam]

I get cytpes error, any solutions fro ur side ?