Skip to content

quickstart-install-connect-ubuntu.md

Latest commit

 

History

History
134 lines (92 loc) · 5.46 KB

quickstart-install-connect-ubuntu.md

File metadata and controls

134 lines (92 loc) · 5.46 KB
title Get started with SQL Server 2017 on Ubuntu | Microsoft Docs
description This quickstart shows how to install SQL Server 2017 on Ubuntu and then create and query a database with sqlcmd.
author rothja
ms.author jroth
manager craigg
ms.date 07/16/2018
ms.topic conceptual
ms.prod sql
ms.component
ms.suite sql
ms.custom sql-linux
ms.technology linux
ms.assetid 31c8c92e-12fe-4728-9b95-4bc028250d85

Quickstart: Install SQL Server and create a database on Ubuntu

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-linuxonly]

In this quickstart, you first install SQL Server 2017 on Ubuntu 16.04. 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.

Prerequisites

You must have a Ubuntu 16.04 machine with at least 2 GB of memory.

To install Ubuntu on your own machine, go to http://www.ubuntu.com/download/server. 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.

Install SQL Server

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

Important

If you have previously installed a CTP or RC release of SQL Server 2017, you must first remove the old repository before registering one of the GA repositories. For more information, see Change repositories from the preview repository to the GA repository.

  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/16.04/mssql-server-2017.list)"

    [!NOTE] This is the Cumulative Update (CU) repository. For more information about your repository options and their differences, see Configure repositories for SQL Server on Linux.

  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] If you are trying SQL Server 2017 in this tutorial, the following 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

  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!

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/16.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.

    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]