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












5 comments:




  1. Very Useful information that i have found. donot stopand Please keep updating us..... Thanks

    ReplyDelete
  2. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us Time Just Went On Reading The article sql server Online Course

    ReplyDelete
  3. Here Informative Contents are solved all My Queries...This Resource is Really Helpful For My Reference.Thanks for Being a parts for support People to Build their Careers...
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

    ReplyDelete
  4. Worthful Sql server tutorial. Appreciate a lot for taking up the pain to write such a quality content on SQL server tutorial.
    Azure Data Factory course in Ameerpet
    Azure Data Engineer Training Online Hyderabad
    azure training in hyderabad ameerpet

    ReplyDelete