How to install SQL Server 2017 online through the official Repo on Linux 7
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!
