Mina Michael Mina Michael - 15 days ago 9
Linux Question

Create an mssql server on Ubuntu

Is there a way to create an mssql server on Linux? Maybe using the ODBC drivers?

Answer

Just about a week ago a public preview of sql server on linux became available.

Installation instructions are described Here.

...so in my case for Ubuntu:

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

then

curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list

and

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

then run this to configure it

sudo /opt/mssql/bin/sqlservr-setup

and this is an extra command to check that everything's working okay

systemctl status mssql-server

...also it's almost unavoidable to install mssql-tools to work on the server (described here):

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

then

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

and

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

I wish I could work on a gui though. There's DbVis but I can't get it to work.

Comments