Skip to content

quickstart-install-connect-ubuntu.md

Latest commit

 

History

History
229 lines (152 loc) · 9.39 KB

quickstart-install-connect-ubuntu.md

File metadata and controls

229 lines (152 loc) · 9.39 KB
title Ubuntu: Install SQL Server on Linux
description This quickstart shows how to install SQL Server 2017 or SQL Server 2019 on Ubuntu and then create and query a database with sqlcmd.
author VanMSFT
ms.author vanto
ms.date 07/15/2020
ms.topic conceptual
ms.prod sql
ms.custom seo-lt-2019
ms.technology linux
ms.assetid 31c8c92e-12fe-4728-9b95-4bc028250d85

Quickstart: Install SQL Server and create a database on Ubuntu

[!INCLUDE SQL Server - Linux]

::: moniker range="= sql-server-linux-2017 || = sql-server-2017"

In this quickstart, you install SQL Server 2017 on Ubuntu 18.04. You then connect with sqlcmd to create your first database and run queries.

Tip

This tutorial requires user input and an internet connection. If you are interested in the unattended or offline installation procedures, see Installation guidance for SQL Server on Linux. For a list of supported platforms, see our Release notes.

::: moniker-end

::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"

In this quickstart, you install SQL Server 2019 on Ubuntu 18.04. You then connect with sqlcmd to create your first database and run queries.

Tip

This tutorial requires user input and an internet connection. If you are interested in the unattended or offline installation procedures, see Installation guidance for SQL Server on Linux. For a list of supported platforms, see our Release notes.

::: moniker-end

Prerequisites

::: moniker range="= sql-server-linux-2017 || = sql-server-2017"

You must have an Ubuntu 16.04 or 18.04 machine with at least 2 GB of memory.

To install Ubuntu 18.04 on your own machine, go to http://releases.ubuntu.com/bionic/. You can also create Ubuntu virtual machines in Azure. See Create and Manage Linux VMs with the Azure CLI.

Note

At this time, the Windows Subsystem for Linux for Windows 10 is not supported as an installation target.

For other system requirements, see System requirements for SQL Server on Linux.

Note

Ubuntu 18.04 is supported starting with SQL Server 2017 CU20. If you want to use the instructions on this article with Ubuntu 18.04, make sure you use the correct repository path, 18.04 instead of 16.04.

If you are running SQL Server on a lower version, the configuration is possible with modifications.

::: moniker-end

::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"

You must have an Ubuntu 16.04 or 18.04 machine with at least 2 GB of memory.

To install Ubuntu 18.04 on your own machine, go to http://releases.ubuntu.com/bionic/. You can also create Ubuntu virtual machines in Azure. See Create and Manage Linux VMs with the Azure CLI.

Note

At this time, the Windows Subsystem for Linux for Windows 10 is not supported as an installation target.

For other system requirements, see System requirements for SQL Server on Linux.

::: moniker-end

::: moniker range="= sql-server-linux-2017 || = sql-server-2017"

Install SQL Server

Note

The following commands for SQL Server 2017 points to the Ubuntu 18.04 repository. If you are using Ubuntu 16.04, change the path below to /ubuntu/16.04/ instead of /ubuntu/18.04/.

To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package.

  1. Import the public repository GPG keys:

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

  2. Register the Microsoft SQL Server Ubuntu repository:

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

    [!TIP] If you want to install SQL Server 2019 , you must instead register the SQL Server 2019 repository. Use the following command for SQL Server 2019 installations:

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

  3. Run the following commands to install SQL Server:

    sudo apt-get update
sudo apt-get install -y mssql-server

  4. After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.

    sudo /opt/mssql/bin/mssql-conf setup

    [!TIP] The following SQL Server 2017 editions are freely licensed: Evaluation, Developer, and Express.

    [!NOTE] Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).

  5. Once the configuration is done, verify that the service is running:

    systemctl status mssql-server --no-pager

  6. If you plan to connect remotely, you might also need to open the SQL Server TCP port (default 1433) on your firewall.

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

::: moniker-end

::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"

Install SQL Server

Note

The following commands for SQL Server 2019 points to the Ubuntu 18.04 repository. If you are using Ubuntu 16.04, change the path below to /ubuntu/16.04/ instead of /ubuntu/18.04/.

To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package.

  1. Import the public repository GPG keys:

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

  2. Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019:

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

  3. Run the following commands to install SQL Server:

    sudo apt-get update
sudo apt-get install -y mssql-server

  4. After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.

    sudo /opt/mssql/bin/mssql-conf setup

    [!NOTE] Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).

  5. Once the configuration is done, verify that the service is running:

    systemctl status mssql-server --no-pager

  6. If you plan to connect remotely, you might also need to open the SQL Server TCP port (default 1433) on your firewall.

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

::: moniker-end

Install the SQL Server command-line tools

To create a database, you need to connect with a tool that can run Transact-SQL statements on the SQL Server. The following steps install the SQL Server command-line tools: sqlcmd and bcp.

Use the following steps to install the mssql-tools on Ubuntu.

  1. Import the public repository GPG keys.

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

  2. Register the Microsoft Ubuntu repository.

    curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

  3. Update the sources list and run the installation command with the unixODBC developer package. For more information, see Install the Microsoft ODBC driver for SQL Server (Linux).

    sudo apt-get update 
sudo apt-get install mssql-tools unixodbc-dev

    [!Note] To update to the latest version of mssql-tools run the following commands:

    sudo apt-get update 
sudo apt-get install mssql-tools

  4. Optional: Add /opt/mssql-tools/bin/ to your PATH environment variable in a bash shell.

    To make sqlcmd/bcp accessible from the bash shell for login sessions, modify your PATH in the ~/.bash_profile file with the following command:

    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

    To make sqlcmd/bcp accessible from the bash shell for interactive/non-login sessions, modify the PATH in the ~/.bashrc file with the following command:

    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

[!INCLUDE Connect, create, and query data]