HI All
Microsoft SQL Server vNext (CTP1) – 14.0.1.246 can now be installed on Linux.
1

I am using Google Cloud Platform to create it.you can do this using https://console.cloud.google.com. get free google cloud usage worth 300 $.

I have selected Red Hat Enterprise Linux 7.

2

It requires minimum RAM of 3.5 GB.so i have selected n1-standard-2 (2 vCPUs, 7.5 GB memory) server,

3

now Linux is read and lets install all latest Service packs in it. click on Open in Browser Window.

sudo yum upgrade

this command will install all available Linux updates.once services pack are installed(no restart required :))

4yumupg

Our Linux  Server is ready.Now lets install SQL Server.

sudo su

This command will start console as a super user.

curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo

this will download setup installation in sql server installation files.

5

lets start setup of sql server using

sudo /opt/mssql/bin/sqlservr-setup

6

we have Installed SQL Server Service.

start SQL Server using

systemctl status mssql-server

7

SQL Server is now.

let’s start and create a rule in firewall now

sudo systemctl start firewalld

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

8

its time to install sql server tools .

9

test our sql server using sql cmd using the below command

sqlcmd -S 104.198.2XX.1X0 -U sa -P Passw0rd

10

here we are done

11

Leave a Reply

Your email address will not be published. Required fields are marked *