How To Install Microsoft SQL Server on CentOS 8

Install Microsoft SQL Server on CentOS 8

In this tutorial, we will show you how to install Microsoft SQL Server on CentOS 8. For those of you who didn’t know, Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network (including the Internet).

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you through the step by step installation Microsoft SQL Server (MS SQL) on CentOS 8.

Install Microsoft SQL Server on CentOS 8

Step 1. First, let’s start by ensuring your system is up-to-date.

Step 2. Installing Microsoft SQL Server on CentOS 8.

We need to add SQL Server 2019 repository:

Next, run the following commands to install SQL Server:

After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition:

Once the configuration is done, verify that the service is running and the service should be started and set to start at boot:

Step 3. Configure Firewall for MS SQL.

The default SQL Server port is TCP 1433. If you are using FirewallD for your firewall, you can use the following commands:

Step 4. Connect to MS SQL server.

Once the installation is complete, connect to the MS SQL server using the following command:

sqlcmd with parameters for your SQL Server name (-S), the user name (-U), and the password (-P).

Congratulations! You have successfully installed Microsoft SQL. Thanks for using this tutorial for installing Microsoft SQL Server (MS SQL) on your CentOS 8 system. For additional help or useful information, we recommend you to check the official Microsoft SQL Server website.

VPS Manage Service Offer
If you don’t have time to do all of this stuff, or if this is not your area of expertise, we offer a service to do “VPS Manage Service Offer”, starting from $10 (Paypal payment). Please contact us to get the best deal!