How to Install MS SQL Server on Centos 7

Linux

Install MS SQL Server 2019 on centos 7

Microsoft SQL Server is a relational database management system developed by Microsoft.Microsoft haved added support for Linux platform in MS SQL Server 2017.Here we will install and perform basic setup of MSSQL in the RHEL based Linux distribution CentOS.

Make sure your system RAM should be 2 to 3 GB and login with root user or any other user with sudo privileges.Here i have loggedin with root user.

Step 1: Install Mssql server

First we need to download and add mssql server 2019 repo

[root@localhost ~]# curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo

Install mssql server 2019 using yum.

Also Read -> How to Install Docker on Centos 7

[root@localhost ~]# yum install -y mssql-server

Once the installation has completed, you have to run /opt/mssql/bin/sqlservr-setup bash script to complete the setup process as shown below.

[root@localhost ~]# /opt/mssql/bin/mssql-conf setup

Select an edition you would like to use

Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID) - CPU Core utilization restricted to 20 physical/40 hyperthreaded
  7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum
  8) I bought a license through a retail sales channel and have a product key to enter.

Here i have selected Evaluation edition,Accept the license terms and set SQL server system administrator password.

Enter your edition(1-8): 1
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=2104078&clcid=0x409
The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409
Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server...

Once the configuration is done, verify that the service is running with the following command.

[root@localhost ~]# systemctl status mssql-server.service

output:

[root@localhost ~]# systemctl status mssql-server.service
● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
   Active: active (running) since Wed 2020-10-21 08:02:47 BST; 1min 26s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 10426 (sqlservr)
   CGroup: /system.slice/mssql-server.service
           ├─10426 /opt/mssql/bin/sqlservr
           └─10446 /opt/mssql/bin/sqlservr

Step 2: Install command line tools

Download and install Microsoft yum repository to install SQL Server tools.

wget https://packages.microsoft.com/config/rhel/7/prod.repo -O /etc/yum.repos.d/msprod.repo

Now install mssql-tools using yum command.

Also Read -> How to Install Webmin on Centos 7

[root@localhost ~]# yum install mssql-tools unixODBC-devel

SQL Server tools has been installed in /opt/mssql/bin directory. Add this directory to your $PATH environment variable as shown below.

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
source ~/.bash_profile

We hope you are following "How to Install MS SQL Server on Centos 7" step by step carefully. The remaining steps will help you to finish the upgrade process..

Step 3: setup firewall

If firewall is running on your system then configure firewall to allow 1433 port so we can access the SQL server from Remote systems.

firewall-cmd --zone=public --add-port=1433/tcp --permanent
firewall-cmd --reload

Step 4: Test connection

To connect database server, run following command

sqlcmd -S localhost -U SA

output:

[root@localhost ~]# sqlcmd -S localhost -U SA
Password:
1>

create test database 

1> CREATE DATABASE lampblogs;
2> GO
1> use lampblogs;
2> GO
Changed database context to 'lampblogs'.

check with following query to return the name of all of the databases.

1> SELECT Name from sys.Databases;
2> GO
Name
--------------------------------------------------------------------------------------------------------------------------------
master
tempdb
model
msdb
lampblogs
(5 rows affected)

Now you have successfully configured MS SQL Server 2019 on CentOS 7 server.

Also Read -> How to Install Nodejs on Centos 7