Hack The Sec-Leading Resource Of Linux Tutorial: Microsoft_SQL

<div dir="ltr" style="text-align: left;" trbidi="on">
Install Microsoft SQL Server (MS SQL) on RHEL (CentOS) / Ubuntu 
 
<a href="https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux">Microsoft has released SQL Server for Redhat Enterprise Linux and Ubuntu</a>; you can now start testing this latest preview of SQL Server in your environment. 
 
This version is still in preview; it is meant for testing and development purpose only. Try it on your own. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZXXcInc-trK4J5NeqAuNa4Zp1jUKqAqbLYFWHmr_gRUuDM5GprjeDL01j0Z1dFRrohPR0IAWRGVZv1iwbZiYcC-1vy2zHboxhDLh95tJ2rgs_yCdwgYVcgrT3r2i7c-kkmws3xsDdKr_k/s1600/mssql_server_on_linux.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZXXcInc-trK4J5NeqAuNa4Zp1jUKqAqbLYFWHmr_gRUuDM5GprjeDL01j0Z1dFRrohPR0IAWRGVZv1iwbZiYcC-1vy2zHboxhDLh95tJ2rgs_yCdwgYVcgrT3r2i7c-kkmws3xsDdKr_k/s1600/mssql_server_on_linux.png" /></a></div>
 
Supported Operating Systems: 
 
Redhat Enterprise Linux 7.2 
Ubuntu 16.04 
 
 
Setup Repository: 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo apt-get install -y wget
$ wget https://packages.microsoft.com/keys/microsoft.asc
$ sudo apt-key add microsoft.asc
$ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql.list
$ curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

### CentOS 7 ###

# yum -y install wget
# wget https://packages.microsoft.com/config/rhel/7/mssql-server.repo
# wget https://packages.microsoft.com/config/rhel/7/prod.repo
# mv *.repo /etc/yum.repos.d/mssql.repo</pre>
Install MS SQL Server on Linux: 
 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo apt-get update
$ sudo apt-get install -y mssql-server

### CentOS 7 ###

# yum install -y mssql-server</pre>
Setup MS SQL server. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo /opt/mssql/bin/sqlservr-setup

### CentOS 7 ###

# /opt/mssql/bin/sqlservr-setup</pre>
 
Output: 
 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">Microsoft(R) SQL Server(R) Setup

You can abort setup at anytime by pressing Ctrl-C. Start this program
with the --help option for information about running it in unattended
mode.

The license terms for this product can be downloaded from
http://go.microsoft.com/fwlink/?LinkId=746388 and found
in /usr/share/doc/mssql-server/LICENSE.TXT.

Do you accept the license terms? If so, please type "YES": YES

Please enter a password for the system administrator (SA) account: Enter Admin Password
Please confirm the password for the system administrator (SA) account: Re Enter Admin Password

Setting system administrator (SA) account password...

Do you wish to start the SQL Server service now? [y/n]: n

You can use sqlservr-setup --start-service to start SQL Server, and
sqlservr-setup --enable-service to enable SQL Server to start at boot.

Setup completed successfully.</pre>
Start the MS SQL Service. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo systemctl start mssql-server
$ sudo systemctl enable mssql-server

### CentOS 7 ###

# systemctl start mssql-server
# systemctl enable mssql-server</pre>
 
Install SQL Server tools on Linux: 
It provides command line tools (sqlcmd and bcp), ODBC drivers and their dependencies. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo apt-get install -y mssql-tools

### CentOS 7 ###

# yum install -y mssql-tools</pre>
Steps: 
 
 
Accept License terms 
 
Firewall (CentOS / RHEL): 
 
Configure the firewall to allow 1433 port so that we can access the SQL server from external machines. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># firewall-cmd --permanent --zone=public --add-port=1433/tcp
# firewall-cmd --reload</pre>
Connect to MS SQL server: 
 
 
Once the installation is complete, connect to MS SQL server using the following command. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sqlcmd -H 127.0.0.1 -U sa

Password: 
1></pre>
 
<a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup">Microsoft Official Document Here</a> 
 
 </div>