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
Featured Online Courses:
- Essential SQL Server Administration Tips (new)
- The Philosophy and Fundamentals of Computer Programming (new)
- Introduction to Azure SQL Database
- SQL Server 2019: What’s New
- Entity Framework: Getting Started (Ultimate Beginners Guide)
- SQL Server Fundamentals (SQL Database for Beginners)
- How to Import and Export Data in SQL Server
- Get Started with SQL Server in 30 Minutes
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)
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).