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

This article mainly introduces "how to install SQL Server in Centos7.7" related knowledge, editor through the actual case to show you the operation process, the method of operation is simple and fast, practical, I hope that this "how to install SQL Server in Centos7.7" article can help you solve the problem.

Preparatory work

System version: Centos7.7, 4G memory (SQL Server memory requires at least 2G), hard disk 40G CPU

SQL Server version: SQL Server 2019, download address

SQL Server Management Studio version: V18.4, installed in windows client download address, Windows 2008R2 (64-bit) or Windows8.1 (64-bit) or above

Close SELINUX

[root@localhost ~] # sed-I'/ ^ SELINUX/s/enforcing/disabled/g' / etc/selinux/config & & setenforce 0 add software source and install dependency package [root@localhost ~] # curl https://packages.microsoft.com/config/rhel/7/prod.repo-o / etc/yum.repos.d/msprod.repo [root@localhost ~] # yum-y install mssql-tools unixODBC-devel bzip2 gdb libsss_nss_idmap cyrus-sasl cyrus-sasl-gssapiCentos7.7 Security Install SQL Server 2019Centos7.7 install SQL Server2019 install SQL Server2019

Download the SQL Server2019 provided above, upload it to the server and install it

[root@localhost] # rpm-ivh mssql-server-15.0.4003.23-3.x86 / 64.rpmenting. # # [100%] Updating / installing... 1:mssql-server-15.0.4003.23-3 # # [100%] +-- + Please Run 'sudo / opt/mssql/bin/mssql-conf setup'to complete the setup of Microsoft SQL Server+---+ run initialization configuration [root@localhost ~] # / opt/mssql/bin/mssql-conf setupusermod: no changesChoose an edition of SQL Server: 1) Evaluation (free No production use rights, 180-day limit) 2) Developer (free No production use rights) 3) Express (free) 4) Web (PAID) 5) Standard (PAID) 6) Enterprise (PAID)-CPU Core utilization restricted to 20 physical/40 hyperthreaded 7) Enterprise Core (PAID)-CPU Core utilization up to Operating System Maximum 8) I bought a license through a retail sales channel and have a product key to enter.Details about editions can be found at https://go.microsoft.com/fwlink/?LinkId=2109348&clcid=0x409Use of PAID editions of this software requires separate licensing through aMicrosoft Volume Licensing program.By choosing a PAID edition You are verifying that you have the appropriatenumber of licenses in place to install and run this software.Enter your edition (1-8): 3 # Express version of The license terms for this product can be found in/usr/share/doc/mssql-server or downloaded from: https://go.microsoft.com/fwlink/?LinkId=2104294&clcid=0x409The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409Do you accept the license terms? [Yes/No]: Yes # enter Yes accept license entry Enter the SQL Server system administrator password: # set SA administrator password Confirm the SQL Server system administrator password:Configuring SQL Server...The licensing PID was successfully processed. The new edition is [Express Edition]. ForceFlush is enabled for this instance.ForceFlush feature is enabled for log durability.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 now starting. Add environment variable [root@localhost ~] # echo 'export PATH=$PATH:/opt/mssql-tools/bin' > / etc/profile.d/mssql.sh [root@localhost ~] # source! $source / etc/profile.d/mssql.sh Firewall add Service [root@localhost ~] # firewall-cmd-- permanent-- add-service=mssqlsuccess [root@localhost ~] # firewall-cmd-- reloadsuccess Command Line tool connection Test [root@localhost ~] # sqlcmd-S localhost-U saPassword: # display system database 1 > select name Database_id from sys.databases # execute 2 > goname database_id -master 1tempdb 2model 3msdb 4 (4 rows affected) # View Software version 1 > SELECT @ @ VERSION2 > go - -Microsoft SQL Server 2019 (RTM-CU1) ( KB4527376)-15.0.4003.23 (X64) Dec 6 2019 14:53:33Copyright (C) 2019 Microsoft CorporationExpress Edition (64-bit) on Linux (CentOS Linux 7 (Core)) (1 rows affected) 1 > Centos7.7 install SQL Server 2019Centos7.7 install SQL Server 2019 connect to the database on the client

Install the SSMS management software provided above, search for "ssms" after installation, open the management software to enter the server address, select "SQL Server Authentication" for authentication, enter the user name and password, and then connect. Check the SQL Server version

This is the end of the introduction on "how to install SQL Server in Centos7.7". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.