How to Offline Install SQL Server on Linux

How to Offline Install SQL Server on Linux

How to Offline Install SQL Server on Linux

Installing SQL Server on a Linux environment with Internet connection is a relatively straightforward process. However what about if you want to offline install SQL Server on Linux?

In this post, we will go through a video tutorial I created, in order to offline install SQL Server 2019 (currently CTP 3.1) on Ubuntu Linux 19.04.

Prior to watching the video tutorial, let’s see the high-level procedure to follow in order to offline install SQL Server on Linux:

 

Step 1: Download the Proper Installation Package

Since in this post, we are talking about installing SQL Server 2019 CTP 3.1 on Ubuntu Linux, we can find links to downloading the proper installation package, in the official MS Docs article “Release notes for SQL Server 2019 preview on Linux“.

From there, you can download the installation package for your Linux distribution.

Similarly, if you are interested installing SQL Server 2017 on Linux, you can find links to downloading the proper installation package, in the official MS Docs article “Release notes for SQL Server 2017 on Linux“.

 

Learn all about SQL Server 2019 on both Windows and Linux

Check my online course on Udemy titled “SQL Server 2019: What’s New” (discount included in link) which among other, has a section dedicated to SQL Server on Linux.

How to Offline Install SQL Server on Linux

 

Step 2: Transfer the Installation Package via SSH on Linux

The next step, is to connect to your Linux environment using SSH, and then copy the installation package there to folder in your file system. A well-known tool for this purpose, which you might want to check is WinSCP.

 

Step 3: Start the Installation of SQL Server on Linux

In this step, you start the installation of SQL Server on Linux, based on the installation package you earlier downloaded and copied via SSH on your Linux file system.

Check the official installation guidance on MS Docs for instructions on how you can begin the installation on the supported Linux distributions.

 

Step 4: Resolve any Missing Dependencies Issues

It might happen to encounter missing dependencies issues, while you are performing the offline installation of SQL Server on your Linux environment.

If you encounter such issue, there are 2 options:

Option 1:

Manually download the missing dependencies installation packages, copy them via SSH in your Linux environment, install them, and try again to install SQL Server.

 

Option 2:

If the Security Policies allows you and you have the necessary approvals, temporarily allow the Linux environment to get Internet access in order to resolve the missing dependencies issue by running the command:

apt-get -f install

 

Step 5: Complete the Installation of SQL Server on Linux

After all the above steps are completed, the next step, is to complete the installation of SQL Server on Linux. You can do that by running the below command:

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

 

Step 6: Check that SQL Server Service is Up and Running

The last step, is to confirm that the SQL Server Database Engine service on Linux, is active (running). You can perform this check, by running the below command:

systemctl status mssql-server

 

Watch the Free Video Tutorial: How to Offline Install SQL Server 2019 on Ubuntu Linux

Feel free to watch my online video tutorial on my YouTube channel! Subscribe to stay up to date with all my video tutorials!

 

Learn more about SQL Server 2019

You can learn more about SQL Server 2019 by accessing the below online resources:

 

Read Also

 

Subscribe to our newsletter and stay up to date!

Check out our latest software releases!

Check out Artemakis’s eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).