A A A

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Installing MSSQL 2016 on RHEL 7
March 19, 2017
1:17 pm
Lo0oM
Admin
Forum Posts: 217
Member Since:
September 30, 2012
Offline

Hi

 

Description:

OS RHEL 7.2, installing MSSQL 2016.

 

Solution:

1. Create 2 yum repositories:

# vi /etc/yum.repos.d/sql-server.repo

[packages-microsoft-com-mssql-server]
name=packages-microsoft-com-mssql-server
baseurl=https://packages.microsoft.com/rhel/7/mssql-server/
enabled=1
gpgcheck=1
gpgkey=https://packages.microsoft.com/keys/microsoft.asc

 

# vi /etc/yum.repos.d/msprod.repo

[packages-microsoft-com-prod]
name=packages-microsoft-com-prod
baseurl=https://packages.microsoft.com/rhel/7/prod/
enabled=1
gpgcheck=1
gpgkey=https://packages.microsoft.com/keys/microsoft.asc

 

2. Install server

# yum install -y mssql-server mssql-tools

 

After installation will be done run script to configure SA password:

# /opt/mssql/bin/mssql-conf setup

 

That's it.

 

You can connect locally with command:

# sqlcmd -S 10.100.23.57 -U SA -P 'Your_password'

>

 

To stop/start: /systemctl stop/start/statusĀ  mssql-server.service

Default port 1433

 

Thank you.

 

 

 

 

 

 

 

 

 

Forum Timezone: UTC 0

Most Users Ever Online: 31

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 0

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 3

Forums: 20

Topics: 214

Posts: 214

Newest Members: Lo0oM

Administrators: Lo0oM (217)