Centos7.7系統下安裝SQL Server 2019

SQL Server 2019 為所有數據工作負載帶來了創新的安全性和合規性功能、業界領先的性能、任務關鍵型可用性和高級分析，現在還支持內置的大數據。

系統版本：Centos7.7 ，內存4G（SQL Server內存要求至少2G），硬碟40G，1核CPUSQL Server版本：SQL Server 2019，下載地址SQL Server Management Studio 版本：V18.4，安裝在windows客戶端下載地址，Windows 2008R2(64位)或Windows8.1(64位)以上

[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

下載文章上面提供的SQL Server2019，上傳到伺服器並安裝

[root@localhost ~]# rpm -ivh mssql-server-15.0.4003.23-3.x86_64.rpm
Preparing... ################################# [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 changes
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): 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 --reload
success

[root@localhost ~]# sqlcmd -S localhost -U sa
Password:
# 顯示系統資料庫
1> select name,database_id from sys.databases;
# 執行
2> go
name database_id
--- -
master 1
tempdb 2
model 3
msdb 4

(4 rows affected)
# 查看軟體版本
1> SELECT @@VERSION
2> 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>

安裝上面提供的SSMS管理軟體，安裝完成之後搜索」ssms」，打開該管理軟體
輸入伺服器地址，身份驗證選擇「SQL Server身份驗證」，輸入用戶名密碼，然後連接。
查看一下SQL Server版本

內存設置為2G的時候，安裝SQL Server2019會出現安裝失敗，提示內存最少為2000M，所以設置不要低於2G內存，安裝還是很簡單的。

本文原創地址：https://www.linuxprobe.com/centos7-instal-mssql-2019.html編輯：逄增寶，審核員：逄增寶

如果喜歡這位作者的文章，點點在看支持一下~

官方站點：www.linuxprobe.com

 Linux命令大全：www.linuxcool.com

Linux系統下載站：www.linuxdown.com

劉遄老師QQ：5604922

Linux技術交流群：193666693

（新群，火熱加群中……）

書籍在線學習（電腦閱讀效果佳）：

http://www.linuxprobe.com/chapter-00.html

    想要學習Linux系統的讀者可以點擊"閱讀原文"按鈕來了解書籍《Linux就該這麼學》，同時也非常適合專業的運維人員閱讀，成為輔助您工作的高價值工具書！