MS SQL Server on Linux

This guide walks you through installing MS SQL Server 2019 on Ubuntu 16.04, and then connecting to the sqlcmd utility to run SQL queries on the database.

Prerequisite

  • Ubuntu 16.04 (either Ubuntu OS or a docker Ubuntu container)
  • Also refer the common Prerequisite section.

Install MS SQL Server

  1. Import the public repository GPG keys:
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
  1. Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019:
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list)"

In case of an error with "missing add-apt-repository", install the package: "software-properties-common"

sudo apt-get update

sudo apt-get install software-properties-common

  1. Run the following commands to install SQL Server:
sudo apt-get update
sudo apt-get install -y mssql-server

Select the geographic area and the timezone.

MS SQL installed on Linux

  1. Run the following command to complete the Microsoft SQL Server setup.
sudo /opt/mssql/bin/mssql-conf setup

Choose your edition and a strong sa (system administrator) password.

On completion of the setup, you get the message: "Setup has completed successfully. SQL Server is now starting".

  1. Once the configuration is done verify that the service is running:
systemctl status mssql-server --no-pager

MS SQL Server running

The above message Active: active (running) confirms the installation.

At this point, SQL Server 2019 is running on your Ubuntu machine and is ready to use!

Install the SQL Server command-line tools

In Ubuntu OS, you need to use the command-line tool sqlcmd to run Transact-SQL statements on the MS SQL database.

Pre-requisite

Install curl on Ubuntu.

sudo apt-get update
sudo apt install curl
  1. Import the public repository GPG keys.
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
  1. Register the Microsoft Ubuntu repository.
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
  1. Update the sources list and run the installation command with the unixODBC developer package.
sudo apt-get update
sudo apt-get install mssql-tools unixodbc-dev
  1. Optional: Add /opt/mssql-tools/bin/ to your PATH environment variable in a bash shell.
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

Connect locally to SQL Server Database Engine

Run sqlcmd utility as:

sqlcmd -S localhost -U SA -P '<YourPassword>'

where,

  • -S: SQL Server name (localhost) to connect locally
  • -U: user name (SA)
  • -P: password entered during setup.

If successful, you should get to the sqlcmd command prompt: 1>

You can now enter your T-SQL commands to connect and transact with the database from Linux.

Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2024 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin