Install a Specific SQL Server Version on Linux Step by Step

By:   |   Comments (4)   |   Related: > SQL Server on Linux


In a previous tip on Installing SQL Server vNext CTP1 on Red Hat Linux 7.2, we read about how we can install SQL Server 2017 on a Linux operating system. We also noticed that this automatically installs the latest update of SQL Server 2017 on Linux which, at the time of writing, is SQL Server 2017 CU19. We have standardized our deployments with SQL Server 2017 CU 16. How do we go about installing a specific version of SQL Server on Linux?


By default, installing SQL Server on Linux will automatically use the latest builds from the Microsoft Package Repositories. So, every time you install SQL Server on Linux, you are guaranteed to get the latest version. While this is a great way to make sure that all your SQL Server on Linux deployments are up to date, there might be cases where you need a specific version. The way to install a specific version of SQL Server on Linux is to explore the different packages on the Microsoft Package Repositories and choose the one that you need. You can check the available packages for RHEL/CentOS 7 (SQL Server 2017 | SQL Server 2019) or Ubuntu 16.04 (SQL Server 2017 | SQL Server 2019). Alternatively, you can also run the command below to list all the available packages for the version of SQL Server on Linux that you want to install. The result of this command will depend on the version of SQL Server that you are trying to install and it is based on the repository configuration file you are using.

#For RHEL/CentOS – SQL Server 2017
sudo yum --showduplicates list mssql-server
linux list sql server components
#For Ubuntu – SQL Server 2017
sudo apt -a list mssql-server
linux list sql server components

Be sure to check the Microsoft official SQL Server 2017 build versions website for the version number that you want to install. Don’t be misled by the Applies to: section of the KB article. While it explicitly says Windows, the SQL Server build numbers are the same on Linux.

The corresponding build number for SQL Server 2017 CU 16 is 14.0.3223.3. Run the command below to install this specific version on RHEL/CentOS.

#For RHEL/CentOS 
sudo yum install -y mssql-server-14.0.3223.3-15

The format to install the specific version is on RHEL/CentOS is mssql-server-buildNumber. The buildNumber is based on the result of previous command - sudo yum --showduplicates list mssql-server on RHEL/CentOS or sudo apt -a list mssql-server on Ubuntu.

Run the command below to install this specific version on Ubuntu.

#For Ubuntu 
sudo apt-get install -y mssql-server=14.0.3223.3-15

The format to install the specific version is on Ubuntu is mssql-server=buildNumber.

Proceed to configure the SQL Server on Linux installation by running the command below. Follow the prompts to choose your SQL Server edition and set the sa password.

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

After the installation and configuration completes, run the command below to enable the SQL Server daemon (service) to launch on server boot.

sudo systemctl enable mssql-server  

And restart the SQL Server daemon (service) for the changes to take effect.

sudo systemctl restart mssql-server  

Be sure to configure the proper firewall rules on your Linux distribution to allow connectivity to SQL Server.

You can verify that the specific version was installed.

check sql server version on linux
Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Edwin Sarmiento Edwin M Sarmiento is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Wednesday, May 22, 2024 - 1:53:07 PM - Edwin M Sarmiento Back To Top (92257)

Upgrades should be treated as projects. And depending on your HA requirements, you should be doing a side-by-side migration instead of an in-place upgrade.

Same thing when moving from Standard Edition to Enterprise Edition.

Sunday, May 19, 2024 - 11:12:06 AM - DiBiEi Back To Top (92252)
Is that works for upgrades to?

How can i upgrade from 2017 to 2019 on Ubuntu?

Or from standard to enterprise?

Thursday, April 28, 2022 - 12:30:53 PM - bass_player Back To Top (90048)
What exactly doesn't work anymore?

Tuesday, April 5, 2022 - 10:03:52 AM - Sheetal Back To Top (89967)
It doesnt work anymore

get free sql tips
agree to terms