In this article, we will be discussing about how to offline install SQL Server on Linux, and see a step-by-step live demonstration.
Introduction
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 – Enroll to our Online Course!
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.
(Lifetime Access, Certificate of Completion, downloadable resources and more!)
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:
Artemakis Artemiou is a seasoned Senior Database and AI/Automation Architect with over 20 years of expertise in the IT industry. As a Certified Database, Cloud, and AI professional, he has been recognized as a thought leader, earning the prestigious Microsoft Data Platform MVP title for nine consecutive years (2009-2018). Driven by a passion for simplifying complex topics, Artemakis shares his expertise through articles, online courses, and speaking engagements. He empowers professionals around the globe to excel in Databases, Cloud, AI, Automation, and Software Development. Committed to innovation and education, Artemakis strives to make technology accessible and impactful for everyone.
Views:7,103
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent. Read More
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
Cookie
Duration
Description
cookielawinfo-checkbox-analytics
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional
11 months
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy
11 months
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.