How to Install and Use MS SQL Server on Linux

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.95/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Gabriel Cánepa

Gabriel Cánepa is a GNU/Linux sysadmin and web developer from Villa Mercedes, San Luis, Argentina. He works for a worldwide leading consumer product company and takes great pleasure in using FOSS tools to increase productivity in all areas of his daily work.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

31 Responses

  1. Mark says:

    Hello Sir please help me i’m not getting it right, using linux mint 18 after the first 2 code when i try sudo /opt/mssql/bin/sqlservr-setup it gives me this sudo: /opt/mssql/bin/sqlservr-setup: command not found

  2. Ryan says:

    Hello, I can connect to my server using the CLI.

    However whenever I try to use mssql in php my login gets denied with the same login details.

    I’m on a Ubuntu server using Apache

  3. mehmet says:

    I’m trying to install SQL Server on Mint.
    when i run setup, I get the following error. any help would be highly appreciated.

    Failed to issue method call: No such interface ‘org.freedesktop.DBus.Properties’ on object at path /org/freedesktop/systemd1/unit/mssql_2dserver_2eservice

    • Gabriel A. Cánepa says:

      What Mint version are you using? In theory this should work in Linux Mint 18.1 and newer. Two constraints here are: 1) Does your Mint version use systemd?, and 2) Is it based on Ubuntu 16.04 LTS, which is the distribution the Microsoft repositories are available for?

  4. singaravelan says:

    Please put on a MS SQL licence registration process details

  5. Arvind says:

    Nice Article. Require once more step to make sqlcmd work.

    Before testing the mssql, make sure to run the following commands

    # ln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd 
    # ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp
    

    After the above commands sqlcmd will work on terminal

  6. Tahiriah says:

    Can’t imagine MIcrosoft product and repository on my GNU system. But I will give a try in order to compare it with postgres or mariadb.

    Thanks for the article

  7. Krzysztof Rogacewicz says:

    Hello, great article. I installed MS SQL on Ubuntu server, everything works fine. I have one problem, How to activate this instance? I want run my production sql server on Linux, but when i restart a instance i got massage that this only 143 days to activate..

    I cant find information on websites how do this… To get help from Microsoft i must have subscription..
    Please help :-)

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

Join Over 300K+ Linux Users
  1. 257,757
  2. 11,967
  3. 39,682

Are you subscribed?