aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
  • Tools
  • About
aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
  • Tools
  • About
  • Data
  • DevOps

How To Install And Configure MsSQL In Ubuntu

  • root
  • July 7, 2019
  • 2 minute read

Overview

This guide contains instructions on how to install and do basic configuration for MsSQL on an Ubuntu system.

 

Prerequisites

  • Operating System : Ubuntu 18.04 or 16.04
  • Access to a Terminal or Shell Console

 

Installation

01: Open a terminal window

 

02: Import the public repository GPG keys

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

 

03: 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)"

 

04: Update the package manager

$ sudo apt update

 

05: Install the SQL Server. Enter y when asked to confirm.

$ sudo apt-get install mssql-server

 

Configuration

06: Run the configuration setup to setup the SQL server edition/license the admin password

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

 

07: Choose an edition of SQL server.

    • 1 – Evaluation
    • 2 – Developer
    • 3 – Express
    • 4 – Web [PAID]
    • 5 – Standard [PAID]
    • 6 – Enterprise [PAID]
    • 7 – Enterprise Core [PAID]
    • 8 – If you have your own license key

For Development purpose, select 2

 

08: Accept the license terms be entering Yes.

 

09: Select the Administrator password, in this example, GeekPassword42

 

It will continue with the process after the password has been entered and confirmed.

 

10: Verify that the service is running

$ systemctl status mssql-server --no-pager

or

$ service msqsql-server status

 

Installing the SQL Server CLI tools

11: Install the tools. Enter y when asked to confirm.

Note that you need to import the public keys and add the Microsoft Ubuntu repository to continue. If you followed the steps in the Installation section, you can continue with the following command. Refer to step #02 and #03.

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

 

Read More  Canonical Ubuntu Core 22 Is Now Available – Optimised For IoT And Embedded Devices

12: A confirmation message will be shown. Confirm by selecting <Ok> using the tab key to highlight it, then Enter.

 

Select <Yes> to confirm.

 

13: Confirm by selecting <Ok>

 

Select <Yes> to confirm.

 

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

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

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

source ~/.bashrc

15: Connect locally using the <b>sqlcmd</b>

$ sqlcmd -S localhost -U SA

 

Then enter your password, example, GeekPassword42

 

16: The prompt will change to 1> when successful. Type QUIT to exit.

root

Related Topics
  • Database
  • How To
  • Installation
  • MsSQL
  • Ubuntu
You May Also Like
View Post
  • DevOps
  • Engineering
  • People

2022 State Of DevOps Report Data Deep Dive: Good Team Culture

  • March 29, 2023
View Post
  • Data
  • Platforms

Google Data Cloud & AI Summit : In Less Than 12 Hours From Now

  • March 29, 2023
View Post
  • DevOps
  • Engineering

Verify POST Endpoint Availability With Uptime Checks

  • March 24, 2023
View Post
  • Computing
  • Data

Sovereign Clouds Are Becoming A Big Deal Again

  • March 23, 2023
View Post
  • Big Data
  • Data

The Benefits And Core Processes Of Data Wrangling

  • March 17, 2023
mobile-laptop-developer-christina-wocintechchat-com-UTw3j_aoIKM-unsplash
View Post
  • Data
  • Software
  • Solutions

Build Customer Trust Through Secure Front End App Development & Cyber Security

  • March 14, 2023
View Post
  • Data
  • Engineering

Sentiment Analysis With BigQuery ML

  • March 13, 2023
View Post
  • Data
  • Engineering

Rapidly Expand The Reach Of Spanner Databases With Read-Only Replicas And Zero-Downtime Moves

  • March 12, 2023

Stay Connected!
LATEST
  • 1
    Kubernetes K8s.gcr.io Redirect: What You Need To Know As An Anthos Or GKE User
    • March 30, 2023
  • 2
    Oracle Helidon Taps Virtual Threads For ‘Pure Performance’
    • March 29, 2023
  • 3
    2022 State Of DevOps Report Data Deep Dive: Good Team Culture
    • March 29, 2023
  • 4
    Google Data Cloud & AI Summit : In Less Than 12 Hours From Now
    • March 29, 2023
  • 5
    A 5-Minute Tour Of The Fediverse
    • March 28, 2023
  • 6
    Bringing Observability To Cloud Security
    • March 28, 2023
  • 7
    How AI Can Improve Digital Security
    • March 27, 2023
  • 8
    Docker’s Bad Week
    • March 27, 2023
  • 9
    My First Pull Request At Age 14
    • March 24, 2023
  • 10
    AWS Chatbot Now Integrated Into Microsoft Teams
    • March 24, 2023
about
Hello World!

We are aster.cloud. We’re created by programmers for programmers.

Our site aims to provide guides, programming tips, reviews, and interesting materials for tech people and those who want to learn in general.

We would like to hear from you.

If you have any feedback, enquiries, or sponsorship request, kindly reach out to us at:

[email protected]
Most Popular
  • 1
    Introducing GPT-4 In Azure OpenAI Service
    • March 21, 2023
  • 2
    IBM And Fundación Ikerbasque Partner To Launch Groundbreaking Quantum Computational Center
    • March 24, 2023
  • 3
    Cleveland Clinic And IBM Unveil First Quantum Computer Dedicated To Healthcare Research
    • March 20, 2023
  • 4
    Verify POST Endpoint Availability With Uptime Checks
    • March 24, 2023
  • 5
    Oracle Cloud Infrastructure to Increase the Reliability, Efficiency, and Simplicity of Large-Scale Kubernetes Environments at Reduced Costs
    • March 20, 2023
  • /
  • Platforms
  • Architecture
  • Engineering
  • Programming
  • Tools
  • About

Input your search keywords and press Enter.