Shulou(Shulou.com)06/01 Report--

This article mainly explains "how to install SQL Server on CentOS". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to install SQL Server on CentOS.

SQL Server is a relational database management system developed by Microsoft Company. It has the advantages of easy to use, good scalability and high integration of related software. it can be used across a variety of platforms, from laptops running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2012.

Note: if you want to run SQL Server 2017 on a Linux distribution, you need at least 3.25GB or more of memory to run smoothly.

The following are operated in the terminal:

1. If you want to install the SQL Server service, you need to switch to superuser permissions, otherwise unexpected errors may occur when downloading the configuration file.

Sudo su

2. Download the SQL Server configuration file for Red Hat Enterprise Edition and CentOS system, and execute the following code directly in the terminal:

Curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > / etc/yum.repos.d/mssql-server.repo

3. Superuser permission is not required after downloading the configuration file. Of course, if you log in using Root, please ignore the following steps:

Exit

4. Then use the yum command to install SQL Server directly. The installation command is as follows:

Sudo yum install-y mssql-server

5. Next, you need to run the SQL Server configuration file and then set a strong password for the account. The password should contain uppercase and lowercase letters and numbers or characters:

Sudo / opt/mssql/bin/mssql-conf setup

6. After successfully configuring the SQL Server account configuration information, verify whether the SQL Server is running. Execute the following code to verify it:

Systemctl status mssql-server

7. If you need to use a remote connection, ask the firewall to open TCP 1433. If you use FirewallD, execute the following command to release the port:

Sudo firewall-cmd-zone=public-add-port=1433/tcp-permanentsudo firewall-cmd-reload

Upgrade SQL Server:

If you want to upgrade the SQL Server service, execute the following command in the terminal to upgrade:

Sudo yum update mssql-server

Uninstall SQL Server:

To uninstall SQL Server, execute the following command in the terminal to uninstall:

Sudo yum remove mssql-server

Then delete the installation path of SQL Server:

Sudo rm-rf / var/opt/mssql/ Thank you for your reading, this is the content of "how to install SQL Server on CentOS". After the study of this article, I believe you have a deeper understanding of how to install SQL Server on CentOS, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.