centos 7 安装 mssql-server

[root@iZbp1dut48get5pemax70aZ ~]# sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 231 100 231 0 0 223 0 0:00:01 0:00:01 --:–:-- 224
[root@iZbp1dut48get5pemax70aZ ~]# sudo yum install -y mssql-server
Loaded plugins: fastestmirror
Determining fastest mirrors
base | 3.6 kB 00:00:00
epel | 4.7 kB 00:00:00
extras | 2.9 kB 00:00:00
packages-microsoft-com-mssql-server-2019 | 3.0 kB 00:00:00
updates | 2.9 kB 00:00:00
(1/8): base/7/x86_64/group_gz | 153 kB 00:00:00
(2/8): epel/x86_64/group_gz | 96 kB 00:00:00
(3/8): base/7/x86_64/primary_db | 6.1 MB 00:00:00
(4/8): epel/x86_64/updateinfo | 1.1 MB 00:00:00
(5/8): extras/7/x86_64/primary_db | 247 kB 00:00:00
(6/8): epel/x86_64/primary_db | 7.0 MB 00:00:00
(7/8): updates/7/x86_64/primary_db | 16 MB 00:00:00
(8/8): packages-microsoft-com-mssql-server-2019/primary_db | 288 kB 00:00:00
Resolving Dependencies
–> Running transaction check
—> Package mssql-server.x86_64 0:15.0.4236.7-1 will be installed
–> Processing Dependency: libatomic for package: mssql-server-15.0.4236.7-1.x86_64
–> Processing Dependency: bzip2 for package: mssql-server-15.0.4236.7-1.x86_64
–> Processing Dependency: gdb for package: mssql-server-15.0.4236.7-1.x86_64
–> Processing Dependency: libsss_nss_idmap for package: mssql-server-15.0.4236.7-1.x86_64
–> Processing Dependency: cyrus-sasl for package: mssql-server-15.0.4236.7-1.x86_64
–> Processing Dependency: cyrus-sasl-gssapi for package: mssql-server-15.0.4236.7-1.x86_64
–> Running transaction check
—> Package bzip2.x86_64 0:1.0.6-13.el7 will be installed
—> Package cyrus-sasl.x86_64 0:2.1.26-24.el7_9 will be installed
—> Package cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 will be installed
—> Package gdb.x86_64 0:7.6.1-120.el7 will be installed
—> Package libatomic.x86_64 0:4.8.5-44.el7 will be installed
—> Package libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.12 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================================================================================================
Package Arch Version Repository Size

Installing:
mssql-server x86_64 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019 254 M
Installing for dependencies:
bzip2 x86_64 1.0.6-13.el7 base 52 k
cyrus-sasl x86_64 2.1.26-24.el7_9 updates 88 k
cyrus-sasl-gssapi x86_64 2.1.26-24.el7_9 updates 41 k
gdb x86_64 7.6.1-120.el7 base 2.4 M
libatomic x86_64 4.8.5-44.el7 base 51 k
libsss_nss_idmap x86_64 1.16.5-10.el7_9.12 updates 169 k

Transaction Summary

Install 1 Package (+6 Dependent packages)

Total download size: 257 M
Installed size: 1.2 G
Downloading packages:
(1/7): bzip2-1.0.6-13.el7.x86_64.rpm | 52 kB 00:00:00
(2/7): cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64.rpm | 41 kB 00:00:00
(3/7): libatomic-4.8.5-44.el7.x86_64.rpm | 51 kB 00:00:00
(4/7): cyrus-sasl-2.1.26-24.el7_9.x86_64.rpm | 88 kB 00:00:00
(5/7): libsss_nss_idmap-1.16.5-10.el7_9.12.x86_64.rpm | 169 kB 00:00:00
(6/7): gdb-7.6.1-120.el7.x86_64.rpm | 2.4 MB 00:00:00
warning: /var/cache/yum/x86_64/7/packages-microsoft-com-mssql-server-2019/packages/mssql-server-15.0.4236.7-1.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID be1229cf: NOKEY======================-] 12 MB/s | 257 MB 00:00:00 ETA
Public key for mssql-server-15.0.4236.7-1.x86_64.rpm is not installed
(7/7): mssql-server-15.0.4236.7-1.x86_64.rpm | 254 MB 00:00:22

Total 11 MB/s | 257 MB 00:00:22
Retrieving key from https://packages.microsoft.com/keys/microsoft.asc
Importing GPG key 0xBE1229CF:
Userid : “Microsoft (Release signing) gpgsecurity@microsoft.com”
Fingerprint: bc52 8686 b50d 79e3 39d3 721c eb3e 94ad be12 29cf
From : https://packages.microsoft.com/keys/microsoft.asc
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : cyrus-sasl-2.1.26-24.el7_9.x86_64 1/7
Installing : gdb-7.6.1-120.el7.x86_64 2/7
Installing : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 3/7
Installing : libsss_nss_idmap-1.16.5-10.el7_9.12.x86_64 4/7
Installing : bzip2-1.0.6-13.el7.x86_64 5/7
Installing : libatomic-4.8.5-44.el7.x86_64 6/7
Installing : mssql-server-15.0.4236.7-1.x86_64 7/7

±-------------------------------------------------------------+
Please run ‘sudo /opt/mssql/bin/mssql-conf setup’
to complete the setup of Microsoft SQL Server
±-------------------------------------------------------------+

Verifying : libatomic-4.8.5-44.el7.x86_64 1/7
Verifying : bzip2-1.0.6-13.el7.x86_64 2/7
Verifying : libsss_nss_idmap-1.16.5-10.el7_9.12.x86_64 3/7
Verifying : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 4/7
Verifying : gdb-7.6.1-120.el7.x86_64 5/7
Verifying : mssql-server-15.0.4236.7-1.x86_64 6/7
Verifying : cyrus-sasl-2.1.26-24.el7_9.x86_64 7/7

Installed:
mssql-server.x86_64 0:15.0.4236.7-1

Dependency Installed:
bzip2.x86_64 0:1.0.6-13.el7 cyrus-sasl.x86_64 0:2.1.26-24.el7_9 cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 gdb.x86_64 0:7.6.1-120.el7 libatomic.x86_64 0:4.8.5-44.el7 libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.12

Complete!
[root@iZbp1dut48get5pemax70aZ ~]# sudo /opt/mssql/bin/mssql-conf setup
Choose 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=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

Enter your edition(1-8): 2
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

Enter the SQL Server system administrator password:
The specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters
Enter the SQL Server system administrator password:
The specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters
Enter the SQL Server system administrator password:
The specified password does not meet SQL Server password policy requirements because it is not complex enough. The password must be at least 8 characters long and contain characters from three of the following four sets: uppercase letters, lowercase letters, numbers, and symbols.
Enter the SQL Server system administrator password:
The specified password does not meet SQL Server password policy requirements because it is not complex enough. The password must be at least 8 characters long and contain characters from three of the following four sets: uppercase letters, lowercase letters, numbers, and symbols.
Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
The passwords do not match. Please try again.
Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server…

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@iZbp1dut48get5pemax70aZ ~]# firewall-cmd --zone=public --add-port=1433/tcp --permanent
FirewallD is not running
[root@iZbp1dut48get5pemax70aZ ~]# firewall-cmd --reload
FirewallD is not running
[root@iZbp1dut48get5pemax70aZ ~]# systemctl enable mssql-server
[root@iZbp1dut48get5pemax70aZ ~]# yum install -y wget && wget -O install.sh http://download.bt.cn/install/install_6.0.sh && sh install.sh ed8484bec
Loade