How to install MSSQL in CENTOS 7?

Step 1 – Install SQL Server

sudo alternatives --config python
# If not configured, install python2 and openssl10 using the following commands: 
sudo yum install python2
sudo yum install compat-openssl10
# Configure python2 as the default interpreter using this command: 
sudo alternatives --config python

# Download the Microsoft SQL Server 2019 Red Hat repository configuration file:
$ sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo

# Run the following commands to install SQL Server:
$ sudo yum install -y mssql-server

# After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.
$ sudo /opt/mssql/bin/mssql-conf setup

# Once the configuration is done, verify that the service is running:
systemctl status mssql-server

# To allow remote connections, open the SQL Server port on the firewall on RHEL. The default SQL Server port is TCP 1433. If you're using FirewallD for your firewall, you can use the following commands:
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload

Step 2 – Install the SQL Server command-line tools

# Download the Microsoft Red Hat repository configuration file.
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

# If you had a previous version of mssql-tools installed, remove any older unixODBC packages.
$ sudo yum remove unixODBC-utf16 unixODBC-utf16-devel

# Run the following commands to install mssql-tools with the unixODBC developer package. 
$ sudo yum install -y mssql-tools unixODBC-devel

# For convenience, add /opt/mssql-tools/bin/ to your PATH environment variable. 
$ echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
$ echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
$ source ~/.bashrc

# Connect locally
sqlcmd -S localhost -U SA -P '<YourPassword>'

# Connect remote - If you later decide to connect remotely, specify the machine name or IP address for the -S parameter, and make sure port 1433 is open on your firewall.
$ sqlcmd -S ip -U SA -P '<YourPassword>'

If successful, you should get to a sqlcmd command prompt: 1>.

$ sqlcmd -S ip -U SA -P '<YourPassword>'  -Q "cmdline query" and exit

sqlcmd -S localhost -U SA -P 'Rajesh123' -Q "sp_databases" >> output.log
grep "master" output.log

• Author
• Recent Posts

Follow me

Rajesh Kumar

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Software AG

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• Installing Jupyter: Get up and running on your computer - November 2, 2024
• An Introduction of SymOps by SymOps.com - October 30, 2024
• Introduction to System Operations (SymOps) - October 30, 2024