SQL SERVER on Linux – Commands

Let us learn how to install SQL Server on Linux in this quick blog post. I have recently worked with a client of Comprehensive Database Performance Health Check who wanted multiple installations of SQL Server on Linux. I have built this quick instruction list which they can just run on their Ubuntu Linux and get started immediately.

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

Step 2: sudo add-apt-repository “$(wget -qO- “

Step 3: sudo apt-get update

Step 4: sudo apt-get install -y mssql-server

Step 5: sudo /opt/mssql/bin/mssql-conf setup

Step 6: systemctl status mssql-server –no-pager

Step 7: hostname -I

Step 8: Connect via your SSMS using the IP address found in Step 7.

That’s it. We are done. You are all set up with your SQL Server on Linux and particularly Ubuntu Linux.

Let me know if you are interested to know more about this topic. I will write more blogs as well as create an SQL in Sixty Seconds video.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Menu
Exit mobile version