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
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!
Learn more about SQL Server 2019
You can learn more about SQL Server 2019 by accessing the below online resources:
- Enroll to my course on Udemy “SQL Server 2019: What’s New”
- SQLNetHub Article on What’s New in SQL Server 2019
- MS Docs article on all the new features in SQL Server 2019
- SQL Server 2019 white paper
- SQL Server 2019 datasheet
- Download SQL Server 2019
Subscribe to our newsletter and stay up to date!
Check out our latest software releases!
Check out Artemakis’s eBooks!
Rate this article:
Reference: SQLNetHub.com (https://www.sqlnethub.com)