How to Install SQL Server 2017 on CentOS7 Step by Step
In this video we are going to learn how to install SQL Server on Linux Step by Step.
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... # 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... 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
https://packages.microsoft.com/config... # 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... 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
How to Install SQL Server 2017 on CentOS 7
nice post...
ReplyDeleteWeb designing and development Training in Coimbatore | HTML Training in Coimbatore| React JS Training in coimbatore | Online React JS Training in coimbatore| Web Development Training in Coimbatore | Online Web Development Training in Coimbatore | Web Designing Course in Saravanampatti | Web Development Institute in Coimbatore | Web Designing Training in Saravanampatti | Online Web Designing Training in Saravanampatti
This SQL video is so great It help me, I provide Bba Thesis help. I really thankfull to you.
ReplyDeletevery informative, Angular Classes In Pune
ReplyDelete