Skip to content

sql-server-linux-setup-ubuntu.md

Latest commit

 

History

History
110 lines (71 loc) · 4.1 KB

sql-server-linux-setup-ubuntu.md

File metadata and controls

110 lines (71 loc) · 4.1 KB
title Install SQL Server on Linux (Ubuntu) | SQL Server vNext CTP1
description
author rothja
ms.author jroth
manager jhubbard
ms.date 10/27/2016
ms.topic article
ms.prod sql-linux
ms.technology database-engine
ms.assetid 31c8c92e-12fe-4728-9b95-4bc028250d85

Install SQL Server on Linux (Ubuntu)

This topic provides a walkthrough of how to install SQL Server vNext CTP1 on Ubuntu 16.04.

Install SQL Server

To install the mssql-server Package on Ubuntu, follow these steps:

  1. Enter superuser mode.

     $ sudo su

    [!IMPORTANT] The following steps will change when we get ready to release. They will look something like this. There will be steps for importing the public keys and registering the repository before the apt-get update / apt-get install commands.

  2. Import the public repository keys:

     # apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv ABC12345

  3. Register the Microsoft SQL Server Ubuntu repository:

     # echo "deb https://packages.microsoft.com/ubuntu/mssql-server main mssql" > /etc/apt/sources.list.d/mssql-server.list

  4. Exit superuser mode.

     # exit

  5. Run the following commands to install SQL Server:

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

  6. After the package installation finishes, run the configuration script and follow the prompts to accept the End-User License Agreement and set the initial password:

     $ sudo /opt/mssql/bin/sqlservr-setup

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

     $ systemctl status mssql-server

Note

Alternatively, you can run this command to install without being prompted for the license agreement and the System Administrator password:

$ sudo ACCEPT_EULA=Y MSSQL_SERVER_SA_PASSWORD=<your pwd> apt-get install mssql-server -y

Verify the installation

Use the following command to print the installed package name and version:

$ dpkg-query -W | grep mssql

Install the tools

The following steps installs the command-line tools, Microsoft ODBC drivers, and their dependencies. For the details on what gets installed, see Command-line tools and ODBC drivers.

Note

If you install these packages from the same Linux machine as your SQL Server installation, you do NOT need to perform steps 1-2 which were done as part of the SQL Server installation.

Important

The following steps will change when we get ready to release.

  1. Download the configuration script and make it executable.

     # curl -O https://private-repo.microsoft.com/tools/configure-mssql-repo-2.sh
 # sudo chmod a+x configure-mssql-repo-2.sh

  2. Pass the unique URL provided for you in your invitation email as a parameter to the script. This URL is labeled as “Package script configuration URL parameter”:

     # sudo ./configure-mssql-repo-2.sh <URL provided in email>

  3. Add the private preview tools repository, and install the SQL Command Line Utilities with its dependencies by running the commands below.

     echo "deb https://private-repo.microsoft.com/ubuntu/mssql-tools-private-preview mssql main" | sudo tee /etc/apt/sources.list.d/mssql-tools.list

  4. Update the sources list and run the installation command:

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

If you are install these packages from the same Linux machine as your SQL Server installation, you can run a test by connecting to your local SQL Server instance (localhost) with your SA username and password:

$ sqlcmd -S localhost -U SA -P <password>

Type exit to return to the command-line.

Next steps

After installation, connect to the SQL Server instance to create and manage databases. To get started, see Connect and query SQL Server on Linux.