Skip to content

quickstart-install-connect-ubuntu.md

Latest commit

 

History

History
113 lines (78 loc) · 4.79 KB

quickstart-install-connect-ubuntu.md

File metadata and controls

113 lines (78 loc) · 4.79 KB
title Get started with SQL Server 2017 on Ubuntu | Microsoft Docs
description This quick start tutorial shows how to install SQL Server 2017 on Ubuntu and then create and query a database with sqlcmd.
author rothja
ms.author jroth
manager jhubbard
ms.date 07/24/2017
ms.topic article
ms.prod sql-linux
ms.technology database-engine
ms.assetid 31c8c92e-12fe-4728-9b95-4bc028250d85

Install SQL Server and create a database on Ubuntu

[!INCLUDEtsql-appliesto-sslinux-only]

In this quick start tutorial, you first install SQL Server 2017 RC2 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 machine with at least 3.25 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.

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.

  1. Import the public repository GPG keys:

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

  2. Register the Microsoft SQL Server Ubuntu repository:

    sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.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 chose your edition.

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

    [!TIP] 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).

    [!TIP] When installing RC2, no purchased licenses are required to try any of the editions. Because it is a release candidate, the following message appears regardless of the edition you select:

    This is an evaluation version. There are [175] days left in the evaluation period.

    This message does not reflect the edition you selected. It relates to the preview period for RC2.

  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.

  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:

    sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)"

  3. Update the sources list and run the installation command with the unixODBC developer package:

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

  4. For convenience, add /opt/mssql-tools/bin/ to your PATH environment variable. This enables you to run the tools without specifying the full path. Run the following commands to modify the PATH for both login sessions and interactive/non-login sessions:

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

Tip

Sqlcmd is just one tool for connecting to SQL Server to run queries and perform management and development tasks. Other tools include SQL Server Management Studio and Visual Studio Code.

[!INCLUDE Connect, create, and query data]