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“.
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:
Manually download the missing dependencies installation packages, copy them via SSH in your Linux environment, install them, and try again to install SQL Server.
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!
Check my Online Courses
I try to explain technical stuff with simplicity and with a “straight to the point” mentality. If you liked my article and also liked my approach of explaining tech stuff, then you should definitely check my online courses.
I regularly update all my courses with additional educational material in order to keep them up to date, and after you enroll to a course, among other, you get lifetime access.
Learn all about SQL Server 2019
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.
Rate this article:
Reference: aartemiou.com (https://www.aartemiou.com)
© Artemakis Artemiou