建站
咨詢
售后
建站咨詢
新聞中心
SQL Serve是微軟發(fā)布的新一代數(shù)據(jù)平臺產(chǎn)品。SQL Server不僅具有現(xiàn)有數(shù)據(jù)平臺的強(qiáng)大能力，全面支持云技術(shù)與平臺，還能夠快速構(gòu)建相應(yīng)的解決方案實(shí)現(xiàn)私有云與公有云之間數(shù)據(jù)的擴(kuò)展與應(yīng)用的遷移，幫助數(shù)以千計的企業(yè)用戶突破性地快速實(shí)現(xiàn)各種數(shù)據(jù)體驗(yàn)，本篇文章重點(diǎn)為大家講解一下Centos7.7安裝SQL Server具體方法。
成都創(chuàng)新互聯(lián)主要從事成都網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計、網(wǎng)頁設(shè)計、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)大姚,十多年網(wǎng)站建設(shè)經(jīng)驗(yàn),價格優(yōu)惠、服務(wù)專業(yè),歡迎來電咨詢建站服務(wù):18980820575
準(zhǔn)備工作
系統(tǒng)版本：Centos7.7 ，內(nèi)存4G（SQL Server內(nèi)存要求至少2G），硬盤40G，1核CPU
SQL Server版本：SQL Server 2019，下載地址
SQL Server Management Studio 版本：V18.4，安裝在windows客戶端下載地址，Windows 2008R2(64位)或Windows8.1(64位)以上
關(guān)閉SELINUX
[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
Centos7.7安裝SQL Server 2019Centos7.7安裝SQL Server 2019
安裝SQL Server2019
下載文章上面提供的SQL Server2019，上傳到服務(wù)器并安裝
[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
+--------------------------------------------------------------+
運(yùn)行初始化配制
[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: #設(shè)置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.
添加環(huán)境變量
[root@localhost ~]# echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh
[root@localhost ~]# source !$
source /etc/profile.d/mssql.sh
防火墻添加服務(wù)
[root@localhost ~]# firewall-cmd --permanent --add-service=mssql
success
[root@localhost ~]# firewall-cmd --reload
success
命令行工具連接測試
[root@localhost ~]# sqlcmd -S localhost -U sa
Password:
# 顯示系統(tǒng)數(shù)據(jù)庫
1> select name,database_id from sys.databases;
# 執(zhí)行
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>
Centos7.7安裝SQL Server 2019Centos7.7安裝SQL Server 2019
在客戶端連接數(shù)據(jù)庫
安裝上面提供的SSMS管理軟件，安裝完成之后搜索”ssms”，打開該管理軟件 輸入服務(wù)器地址，身份驗(yàn)證選擇“SQL Server身份驗(yàn)證”，輸入用戶名密碼，然后連接。 查看一下SQL Server版本
總結(jié)
內(nèi)存設(shè)置為2G的時候，安裝SQL Server2019會出現(xiàn)安裝失敗，提示內(nèi)存最少為2000M，所以設(shè)置不要低于2G內(nèi)存，安裝還是很簡單的。
網(wǎng)頁題目：Centos7.7安裝SQLServer具體方法
網(wǎng)頁鏈接：http://fisionsoft.com.cn/article/cosoecc.html
