installation on centos:-

Requirement:

• You need at least 3.25GB of memory to run SQL Server on Linux.
• SQL Server Engine has been tested up to 1 TB of memory at this time. The file system must be XFS or EXT4. Other file systems, such as BTRFS, are unsupported. 

                mount | grep "^/dev"       --check file system should             

• you need  administrative access for installation.

            sudo -l -U msdba   -->User msdba is not allowed to run sudo on servername

Login with superuser

Sudo su 

#cat /etc/centos-release  --check version

     CentOS Linux release 7.3.1611 (Core)

 copy repo file in  /etc/yum.repos.d/ directory only using winscp. 

Install mssql using yum install.  

sudo yum install -y mssql-server

Configuration and setting SA password with strong password.

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
















 Check mssql services  packages is installed 

  root #rpm -qa | grep mssql
















Check mssql services is running.





  root # systemctl status mssql-server
















Enable firewall rule  





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









Install mssql agent 







sudo yum install mssql-server-agent

sudo systemctl restart mssql-server














remove old version






sudo yum update

sudo yum remove unixODBC-utf16 unixODBC-utf16-devel














 Install mssql tools with unixODBC developer packages. 











sudo yum update

sudo yum install mssql-tools unixODBC-devel














 Login in mssql using Sqlcmd






[root]# sqlcmd -S 10.16.1.54 -U sa

Password:

1> select @@version

2> go

Microsoft SQL Server vNext (CTP2.0) - 14.0.500.272 (X64)         Apr 13 2017 11:44:40         Copyright (C) 2017 Microsoft Corporation. All rights reserved.  Developer Edition (64-bit) on Linux (CentOS Linux 7 (Core))







check packgae information of mssql






# yum info mssql-server