Can linux install sqlserver?

Linux can install sqlserver; sqlserver is a relational database management system developed and promoted by Microsoft and can be supported on "Red Hat Enterprise Linux (RHEL)", "SUSE Linux Enterprise Server (SLES)" and Ubuntu , you can use "yum install -y mssql-server" to install.

#The operating environment of this tutorial: linux7.3 system, Dell G3 computer.

linux can install sqlserver

SQL Server is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES) and Ubuntu. Additionally, it is also available as a Docker image that runs on Docker Engine on Linux or Docker for Windows/Mac.

SQL Server has the following system requirements for Linux:

If you are using Network File System (NFS) remote shares in production, please note the following support requirements:

Use NFS version 4.2 or higher. Older versions of NFS do not support required features common to modern file systems, such as fallocate and sparse file creation.

Only look for the /var/opt/mssql directory on NFS mounts. Other files, such as SQL Server system binaries, are not supported.

When mounting a remote share, make sure the NFS client uses the "nolock" option.

The example is as follows:

Start installing SQLserver (2017 example)

1. Download the Microsoft SQL Server Red Hat repository configuration file:

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

2. Run the following command to install SQL Server:

yum install -y mssql-server

If an error is reported when running this command, it is an environmental problem. Do not install the minimized version.

3. Run mssql after the package installation is completed. -conf installation and follow the prompts step by step.

/opt/mssql/bin/mssql-conf setup

4. Select the version of SQL Server. You can choose according to your own needs

• Evaluation (free, no production license, 180 days limit)

• Developer (Free, no production license)

• Express (Free)

• Web (Paid version)

• Standard (paid version)

• Enterprise (paid version)

• ##Enterprise Core (paid version)

I purchased the license through retail and have a product key to enter.

5. Agree to the license terms

6. Select language

7. Set the SA account password (minimum 8 characters, including uppercase and lowercase letters, decimal numbers and/or Non-alphanumeric symbols)

At the end of the installation, the system will prompt as follows:

Configuring SQL Server...

Created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service.

The installation program has been successfully completed. SQL Server is starting.

Verify whether the service is running:

systemctl status mssql-server

If the running result is as above (normally green), the service is running normally.

If you want to allow remote connections, you need to open the SQL Server port on the firewall

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

Restart

firewall-cmd --reload

The above completes the installation of SQL Server 2017

Recommended learning:

Linux video tutorial

The above is the detailed content of Can linux install sqlserver?. For more information, please follow other related articles on the PHP Chinese website!