Thursday, December 15, 2016

SQL Server 2016 installtion on Linux

Dear All,

Come back after long time . I am going to discussing about SQL Server installation on Linux ,
This is one of the great step by Microsoft. If this success we could see SQL Server Database as NO.1 in Market.

Recently Microsoft released SQL Server vNext CTP1 installation on RED Hat Enterprise Linux 7.2 

Prerequisites for installing the SQL Server .
1)at least 3.5 RAM required for installing the SQL Server 
2) OS :  RHEL 7.2 

Install SQL Server Step by Step on Linux .

1)Logging into Linux with Super User mode .( Need to login into server with sudo account )

  sudo su  ( same as local administrator  permission )

2) Download the Microsoft SQL Server Red Hat  repository configuration file from blew site.
curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo
3)Run below command to install the SQL Server


sudo yum install -y mssql-server

4) After package installation completes , run the below configuration script and provide the strong password for SA(minimum 8 characters  length).


sudo /opt/mssql/bin/sqlservr-setup


5) Verify that SQL Server service running status with following command.

systemctl status mssql-server
6) Install the SQL Server tools .
        SQL Server tools contains following tools and utilities 

           command-line tools,
          Microsoft ODBC drivers, and their dependencies.
          sqlcmd: Command-line query utility
          bcp: Bulk import-export utility.

7) Same process which we have followed before starting the installation .

enter with Sudo account 

8) download the Microsoft Red Hat repository.
 




curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo

9) Run the following commands to install SQL tools 


sudo yum install mssql-tools

Thanks
ASR