Document for
Installation of Microsoft SQL Server 2017
Along with DC DR setup configuration on RHEL Platform.
Documentation on:
Microsoft SQL Server installation and
DC DR Set configuration.
Platform used: RHEL 7.3, Windows
Client.
For file sharing: NFS mount has been
used.
Prepared By: Tapas Kumar Karmakar.
Oracle Consultant.
Tested in my VMware Workstation setup.
Table
of Contents
Purpose of the DOCUMENT
As we all aware that Microsoft has announced now
SQL Server can be installed and operated on Linux platform too.
So now as a DBA we all must know how to Install
Microsoft SQL server 2017 on RHEL platform.
Even this documentation contains
information for configuration of log shipping in RHEL platform.
Some of the information related to prerequisites
has been gathered from Microsoft website.
Scope of
the DOCUMENT
The Document and the operational processes
contained herein can only be used to accomplish the suggested activities based
on the policies.
Workflow
Navigation
For installation of Microsoft SQL Server 2017.
Basic requirements for Installation used for
testing and setup are viz.
A RHEL
7.3
a. DC
Server IP: 192.168.209.251 hostname sqlrheldc01.
b. DR
Server IP: 192.168.209.252 hostname sqlrheldr01.
A. Users
and Group required in server.
One user with mssql and group as mssql server
required in server
B. MSSQL
user need to be added to sudo group for performing admin privileges.
D. Services need to be configured in server are.
a. nfs
b. nfs-server
c.rpcbind
E. Yum server required.
F. YUM REPO CREATION.
G. NFS File mount
Microsoft
SQL Server installation Steps
1.
Pre-Requisites:
2.
Package Details.
3.
Supported client tools
4.
RPM Installation.
For installation of SQL Server 2017 on Linux
following RPM are required to be installed on server.
omi-1.2.0-35.ulinux.x64.rpm
psrp-1.0.0-18.universal.x64.rpm
packages-microsoft-prod-1.0-1.el7.noarch.rpm
powershell-6.0.0_alpha.18-1.el7.centos.x86_64.rpm
unixODBC-2.3.1-11.el7.x86_64.rpm / unixODBC-utf16-2.3.1-1.x86_64.rpm
unixODBC-devel-2.3.1-11.el7.x86_64.rpm / unixODBC-utf16-devel-2.3.1-1.x86_64.rpm
For installation of rpm on RHEL server commands are.
yum install -y
file_name
OR
Rpm -ivh file_name.rpm
a.
RPM mssql-server Package installation
b.
After mssql-server package installation Sql-Server
Setup need to be performed.
c. Mssql-Server-tools
rpm installation.
d.
After installing mssql-serve-tools, mssql-server
Service needs to be restarted.
e. Mssql-Server-fts installation rpm installation.
f. Mssql-Server msodbcsql rpm installation
g. Mssql-tools rpm installation
h.
Omi rpm installation
i. Powershell rpm install
j. PSRP
rpm installation
k. Package Microsoft rpm installation
1.
Database connection for Client
After
successful installation of rpm packages on the servers.
Next step is
to check the databases of DC and DR setup from client SSMS from any windows
server/client.
a.
Screen shot for sql server connection from
client to DC server.
b. Screen
shot for sql server connection from client to DR server.
1.
Create new DB in DC Server.
Created new database named as PRDB in DR Database.
a.
Right click on Database -> click on New
Database
b.
Enter the details for new database and then
click on ok.
c. Screen shot for new database created.
1.
Activity needs to be performed for setting up DR database.
a.
Step 1 is to enable log shipping for DC
database.
For this right click on newly created
database -> click on database properties.
b.
Select Transaction log shipping and click on ok.
c.
Click on enable this as primary database in a
log shipping configuration. And click on backup settings.
d. Now enter the details for backup of log files,
click on ok
e. Click on use a monitor server instance.
f. Click on settings -> connect -> enter the
database details.
g. Click on ok. In this stage log shipping process
started.
h. Click on ok. In this stage log shipping process
started.
Now click on close.
i. Now steps to perform standby database for DR
setup.
Right click on DB Properties -> click on
transaction log shipping -> click on add -> click on connect
j. Enter the details for DR server and enter the
details.
k. Now after connecting the DR server this screen
will appear.
l. Select copy files tab and enter the details.
m. Select restore transaction log tab and select
Standby mode and disconnect users button.
n. Click on ok.
o. Standby database set will start.
p. Screenshot for DR set up creation. Click on
close and proceed.
8.
Check connection for DC and DR database through client.
a.
Connect to DC and DR database.
9.
Check connection for DC and DR database through client.
