How to Install SQL Server on Linux CentOS 7 – SQL Server on Linux Tutorial
In this video we are going to learn how to install SQL Server on Linux Step by Step.
You will learn below items in this video
How to Configure SQL Server Repository
Download SQL Server Red Hat Repository configuration File
Install SQL Server using yum Command
Configure SQL Server and setup SA Password
Restart SQL Server services
Open Firewall port to allow remote connection to SQL Server
Enable and start SQL Server Agent Services
Download and Install SQL server Tools to connect to SQL Server
Connecting to SQL Server using SSMS 2017 with SQL Server Authentication
Scripts used in this video:
# Let’s check if mssql-server repository already exists?
sudo ls /etc/yum.repos.d | grep mssql-server.repo
# If it does, we need to check contents of this repository and remove that, otherwise we will face issues during the install
sudo cat/etc/yum.repos.d/mssql-server.repo
sudo rm -rf /etc/yum.repos.d/mssql-server.repo
# Configure and Download SQL Server Repository
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
# Install SQL Server using below commands
sudo yum install -y mssql-server
# Configure SQL Server and Setup SA password
sudo /opt/mssql/bin/mssql-conf setup
# Restart SQL Server Services
systemctl restart mssql-server
# Configure repository and install Sqlcmd and other Tools to internally connect to newly installed SQL Server
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo
sudo yum install -y mssql-tools unixODBC-devel
#Set Environment Tools to your Path Environment
# Connect to SQL Server using sqlcmd tool
sqlcmd -S localhost -U SA -P Pass@123
# Connect to SQL Server Remotely using SQL Server Authentication
SSMS – Error and Resolution
# Enable Firewall port 1433
sudo firewall-cmd –zone=public –add-port=1433/tcp –permanent
sudo firewall-cmd –reload
# Enable and start SQL Server Agent services
sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
install sql server on centos 7
install sql server 2017 on CentOS 7
install sql server management studio on linux
source
centos 7
