Centos7.7系统下安装SQL Server 2019

[root@localhost ~]# sed -i '/^SELINUX/s/enforcing/disabled/g' /etc/selinux/config && setenforce 0

[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-gssapi

[root@localhost ~]# rpm -ivh mssql-server-15.0.4003.23-3.x86_64.rpmPreparing...                          ################################# [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+--------------------------------------------------------------+

[root@localhost ~]# /opt/mssql/bin/mssql-conf setup usermod: 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 athttps://go.microsoft.com/fwlink/?LinkId=2109348&clcid=0x409 Use 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版本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=0x409 The privacy statement can be viewed at:https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409 Do you accept the license terms? [Yes/No]:Yes	#输入Yes接受许可条目 Enter the SQL Server system administrator password: 		#设置SA管理员密码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.

[root@localhost ~]# echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh [root@localhost ~]# source !$source /etc/profile.d/mssql.sh

[root@localhost ~]# firewall-cmd --permanent --add-service=mssql success[root@localhost ~]# firewall-cmd --reloadsuccess

[root@localhost ~]# sqlcmd -S localhost -U saPassword: # 显示系统数据库1> select name,database_id from sys.databases;# 执行2> goname                                                                                                                             database_id-------------------------------------------------------------------------------------------------------------------------------- -----------master                                                                                                                                     1tempdb                                                                                                                                     2model                                                                                                                                      3msdb                                                                                                                                       4 (4 rows affected)# 查看软件版本1> SELECT @@VERSION2> go                                                                                                                                                                                                                                                                                                            ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Microsoft SQL Server 2019 (RTM-CU1) (KB4527376) - 15.0.4003.23 (X64) 	Dec  6 2019 14:53:33 	Copyright (C) 2019 Microsoft Corporation	Express Edition (64-bit) on Linux (CentOS Linux 7 (Core))                                                                                                       (1 rows affected)1>