Can linux install sqlserver?

Designed for programming, automatic code writing robot, free to open. Most people don't quite understand the knowledge of this article about whether linux can install sqlserver, so Xiaobian summed up the following contents, with detailed contents and clear steps, which has certain reference value. I hope everyone can gain something after reading this article. Let's take a look at this article about whether linux can install sqlserver.

Linux can install sqlserver；; Sqlserver is a relational database management system developed and popularized by Microsoft, which can be supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES) and Ubuntu, and can be installed by using yum install -y mssql-server.

Operating environment of this tutorial: linux7.3 system and Dell G3 computer.

Linux can install sqlserverSQL Server is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES) and Ubuntu. In addition, it can also be provided as a Docker image, which can run on Docker engine on Linux or Docker for Windows/Mac.

SQL Server has the following system requirements for Linux:

If you use Network File System (NFS) remote sharing in production, please note the following support requirements:

Use NFS version 4.2 or later. Earlier versions of NFS did not support the necessary functions commonly used in modern file systems, such as fallocate and sparse file creation.

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

When installing remote sharing, ensure that NFS clients use the nolock option.

Examples are as follows:

Start installing SQLserver (taking 2017 as an 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 you report an error when running this command, it is an environmental problem. Don't minimize it.

3. After installing the running package, install mssql-conf and follow the prompts step by step.

/opt/mssql/bin/mssql-conf setup

4. Choose the version of SQL Server, and everyone can choose according to their own needs.

Evaluation (free, no production license, 180-day limit)

Developer (free, no production license)

Express (free)

Web (paid version)

Standard (paid version)

Enterprise (paid version)

Enterprise Core (paid version)

I bought the license through the retail channel and have the product key to enter.

5. Agree to the license terms

6. Choose a language

7. Set the SA account password (at least 8 characters, including uppercase and lowercase letters, decimal digits 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.

Setup has completed successfully. SQL Server is starting.

Verify that 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 connection, you should open the SQL Server port on the firewall.

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

Restart.

firewall-cmd --reload

The above is the content of this article about whether linux can install sqlserver. I believe everyone has a certain understanding. I hope that the content shared by Xiaobian will be helpful to everyone. If you want to know more about the relevant knowledge, please pay attention to the Yisu Cloud Industry Information Channel.

Ask AI for details