Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to install SQL Server 2017 online through the official Repo on Linux 7. The article is very detailed and has a certain reference value. Interested friends must read it!

Mount the data disk

# Total PE of vgdispaly

Install the SQL Server server

1. Download the 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

two。 Install SQL Server instance

Yum install-y mssql-server

3. Run mssql-conf setup and follow the prompts to configure, select the version, and set the SA password.

/ opt/mssql/bin/mssql-conf setup

4. Verify that the service is functioning properly:

Systemctl status mssql-server

5. Disable firewalld

Systemctl status firewalldsystemctl stop firewalldsystemctl disable firewalld

6. Disable selinux

Getenforcesetenforce 0vi / etc/sysconfig/selinux

Change the SELINUX value to disabled

Install the SQL Server command line tool

To create a database, you need to use a tool that connects to Transact SQL statements that run on SQL Server. The following are the SQL Server command line tools: sqlcmd and bcp.

1. Download the Red Hat Repo configuration file.

Curl-o / etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

two。 Uninstall the old unixODBC package.

Yum remove unixODBC-utf16 unixODBC-utf16-devel

3. Install command line tools

Yum install-y mssql-tools unixODBC-devel

4. Add / opt/mssql-tools/bin/ to the PATH environment variable.

Echo 'export PATH= "$PATH:/opt/mssql-tools/bin' > > ~ / .bash_profileecho 'export PATH=" $PATH:/opt/mssql-tools/bin "> > ~ / .bashrcsource ~ / .bashrc local connection

The above is all the contents of the article "how to install SQL Server 2017 online through the official Repo on Linux 7". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow 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.