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

Most people do not understand the knowledge points of this article "how to install Linux system SQLserver", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "Linux system how to install SQLserver" article.

About SQLserver: SQL is an acronym for structured query language, which represents structured query language.

The main function of SQL language is to establish contact and communicate with various databases.

According to ANSI (American National Standards Institute) regulations, SQL is used as the standard language for relational database management systems.

SQLServer is a relational database management system (RDBMS) developed and promoted by Microsoft.

Detailed steps of installing SQLserver in Linux system: I. requirements

Systems above 1.centos or redhat7.0

two。 More than 2GB of memory

Second, installation steps

1. Set up the sqlserver installation image

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

two。 Perform installation

Yum install-y mssql-server

After that, run sudo / opt/mssql/bin/mssql-conf setup to do the relevant configuration.

Image

Enter 2 to use the Developer (free, no production license) version

Image.png

Enter yes to accept the license terms

Image.png

Enter 10 and select the language as simplified Chinese

Image.png

Set the account password for sa, which requires 8 digits containing uppercase and lowercase letters and numbers. It is recommended to set 1234Qwer.

After that, you can start and complete. If the installation fails, re-order sudo / opt/mssql/bin/mssql-conf setup.

3. Let's take a look at the version of sql server we installed

Rpm-qa | grep mssql

4. View the path of installation

Find /-name mssql

5. Set up boot boot

Systemctl enable mssql-server

6. Open port 1433

Firewall-cmd-zone=public-add-port=1433/tcp-permanent

Firewall-cmd-reload

7. A few orders.

Systemctl start mssql-server

Systemctl restart mssql-server

Systemctl stop mssql-server

Systemctl status mssql-server

The specific configuration of Lujin is / opt/mssql/bin/mssql-conf

The above is about the content of this article on "how to install SQLserver in Linux system". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more related knowledge, please pay attention to the industry information channel.

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.