Sql server数据库打个
CVE-2021-1636
Microsoft SQL Server Elevation of Privilege Vulnerability - January 2021
影响
An authenticated attacker can send data over a network to an affected SQL Server when configured to run an Extended Event session.
FAQ
How can an attacker exploit this vulnerability? An authenticated attacker can send data over a network to an affected SQL Server when configured to run an Extended Event session.
There are GDR and/or CU (Cumulative Update) updates offered for my version of SQL Server. How do I know which update to use?
- First, determine your SQL Server version number. For more information on determining your SQL Server version number, see Microsoft Knowledge Base Article 321185 - How to determine the version, edition, and update level of SQL Server and its components.
- Second, in the table below, locate your version number or the version range that your version number falls within. The corresponding update is the one you need to install.
Note If your SQL Server version number is not represented in the table below, your SQL Server version is no longer supported. Please upgrade to the latest Service Pack or SQL Server product in order to apply this and future security updates.
| Update number | Title | Apply if current product version is… | This security update also includes servicing releases up through… |
|---|---|---|---|
| 4583458 | Security update for SQL Server 2019 RTM GDR: Jan 12, 2021 | 15.0.2000.5 - 15.0.2070.41 | KB 4517790 - Previous SQL19 RTM GDR |
| 4583459 | Security update for SQL Server 2019 RTM CU8: Jan 12, 2021 | 15.0.4003.23 - 15.0.4073.23 | KB 4577194 – SQL19 RTM CU8 |
| 4583456 | Security update for SQL Server 2017 RTM GDR: Jan 12, 2021 | 14.0.1000.169 - 14.0.2027.2 | KB4505224 - Previous SQL17 RTM GDR |
| 4583457 | Security update for SQL Server 2017 RTM CU22: Jan 12, 2021 | 14.0.3006.16 - 14.0.3356.20 | KB4577467 – SQL17 RTM CU22 |
| 4583460 | Security update for SQL Server 2016 Service Pack 2 (GDR): Jan 12, 2021 | 13.0.5026.0 - 13.0.5102.14 | KB4532097 - Previous SQL16 SP2 GDR |
| 4583461 | Security update for SQL Server 2016 Service Pack 2 CU15: Jan 12, 2021 | 13.0.5149.0 - 13.0.5850.14 | KB4577775 – SQL16 SP2 CU15 |
| 4583463 | Security update for SQL Server 2014 Service Pack 3 (GDR): Jan 12, 2021 | 12.0.6024.0 - 12.0.6118.4 | KB4532095 - Previous SQL14 SP3 GDR |
| 4583462 | Security update for SQL Server 2014 Service Pack 2 CU4: Jan 12, 2021 | 12.0.6205.1 - 12.0.6372.1 | KB4535288 – SQL14 SP3 CU4 |
| 4583465 | Security update for SQL Server 2012 Service Pack 4 (QFE): Jan 12, 2021 | 11.0.7001.0 - 11.0.7493.4 | KB4532098 – Previous SQL12 SP4 QFE |
What are the GDR and CU update designations and how do they differ?
The General Distribution Release (GDR) and Cumulative Update (CU) designations correspond to the two different servicing options in place for SQL Server baseline releases. A baseline can be either an RTM release or a Service Pack release.
- GDR updates – cumulatively only contain security updates for the given baseline.
- CU updates – cumulatively contain all functional fixes and security updates for the given baseline.
For any given baseline, either the GDR or CU updates could be options (see below).
- If SQL Server installation is at a baseline version, you can choose either the GDR or CU update.
- If SQL Server installation has intentionally only installed past GDR updates, then choose to install the GDR update package.
- If SQL Server installation has intentionally installed previous CU updates, then chose to install the CU security update package.
Note: You are allowed to make a change from GDR updates to CU updates ONE TIME. Once a SQL Server CU update is applied to a SQL Server installation, there is NO way to go back to the GDR update path.
Can the security updates be applied to SQL Server instances on Windows Azure (IaaS)?
Yes. SQL Server instances on Windows Azure (IaaS) can be offered the security updates through Microsoft Update, or customers can download the security updates from Microsoft Download Center and apply them manually.
官方FAQ中满足以上版本要求的数据库可以使用补丁，不满足要求数据库需要先升级到以上版本。
12.0.6024.0，之后应用补丁
1.确认数据库版本信息
SELECT SERVERPROPERTY('productversion') as productversion,
SERVERPROPERTY ('productlevel') as productlevel,
SERVERPROPERTY ('edition') as edition
productversion productlevel edition
12.0.2000.8 RTM Enterprise Edition (64-bit)
我需要打两个patch，12.0.2000.8->12.0.6024.0(KB4505218)->CVE-2021-1636
a.SQ Server 2014 SP3 安全更新程序 (KB4505218)
b.Jan 12, 2021 Microsoft SQL Server 2014 Service Pack 3 for x64-based Systems (CU 4) (KB4583462)
CU的注解：
- GDR updates – cumulatively only contain security updates for the given baseline.
- CU updates – cumulatively contain all functional fixes and security updates for the given baseline.
2.确认数据库语言
use master
select SERVERPROPERTY(N'edition') as Edition --数据版本，如企业版、开发版等
,SERVERPROPERTY(N'collation') as Collation --数据库字符集
,SERVERPROPERTY(N'servername') as ServerName --服务名
,@@VERSION as Version --数据库版本号
,@@LANGUAGE AS Language --数据库使用的语言
Edition Collation ServerName Version Language
Enterprise Edition (64-bit) Chinese_PRC_CI_AS WIN-HSLS4EV196N Microsoft SQL Server 2014 - 12.0.2000.8 (X64)
Feb 20 2014 20:04:26
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
简体中文中文的数据库需要安装中文的sp3的补丁，如果语言不一致会报如下错误：
3.升级2014sp3
Overall summary:
Final result: 已通过
Exit code (Decimal): 0
Start time: 2022-08-04 13:49:45
End time: 2022-08-04 14:43:50
Requested action: Patch
Instance MSSQLSERVER overall summary:
Final result: 已通过
Exit code (Decimal): 0
Start time: 2022-08-04 14:16:58
End time: 2022-08-04 14:42:54
Requested action: Patch
Machine Properties:
Machine name: WIN-HSLS4EV196N
Machine processor count: 2
OS version: Windows Server 2012
OS service pack:
OS region: 中华人民共和国
OS language: 中文(中华人民共和国)
OS architecture: x64
Process architecture: 64 位
OS clustered: 否
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER 数据库引擎服务 1033 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER 数据库引擎服务 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER SQL Server 复制 1033 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER SQL Server 复制 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER 全文和语义提取搜索 1033 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Data Quality Services 1033 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Data Quality Services 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSAS12.MSSQLSERVER Analysis Services 1033 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSAS12.MSSQLSERVER Analysis Services 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSRS12.MSSQLSERVER Reporting Services - 本机 1033 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 MSSQLSERVER MSRS12.MSSQLSERVER Reporting Services - 本机 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 管理工具 - 基本 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 管理工具 - 完整 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 客户端工具连接 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 客户端工具向后兼容性 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 客户端工具 SDK 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 数据质量客户端 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 Integration Services 2052 Enterprise Edition 12.0.2000.8 否 是
SQL Server 2014 Reporting Services - SharePoint 12.0.2000.8 否 是
SQL Server 2014 Master Data Services 1033 Enterprise Edition 12.0.2000.8 否 是
Package properties:
Description: Microsoft SQL Server 2014
ProductName: SQL Server 2014
Type: RTM
Version: 12
SPLevel: 3
KBArticle: KB4022619
KBArticleHyperlink: http://support.microsoft.com/?kbid=4022619
PatchType: SP
AssociatedHotfixBuild: 0
Platform: x64
PatchLevel: 12.3.6024.0
ProductVersion: 12.0.2000.8
GDRReservedRange: 12.0.2200.0:12.0.2290.0;12.0.4200.0:12.0.4299.0;12.0.5200.0:12.0.5399.0
Installation location: c:\0df1202ff18eff318843b0e3a4d9\x64\setup\
Updated product edition:
Instance Edition
MSSQLSERVER Enterprise
用户输入设置:
ACTION: Patch
ALLINSTANCES: false
CLUSTERPASSIVE: false
CONFIGURATIONFILE:
ENU: false
ERRORREPORTING: false
HELP: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTANCEID: <空>
INSTANCENAME: <空>
QUIET: false
QUIETSIMPLE: false
SQMREPORTING: false
UIMODE: Normal
X86: false
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20220804_134933\SystemConfigurationCheck_Report.htm
4.升级CVE-2021-1636
5.版本比对
a.SELECT SERVERPROPERTY('productversion') as productversion,
SERVERPROPERTY ('productlevel') as productlevel,
SERVERPROPERTY ('edition') as edition
productversion productlevel edition
12.0.6433.1 SP3 Enterprise Edition (64-bit)
b.select @@version
Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64)
Oct 31 2020 02:54:45
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
补丁链接：
a.SQ Server 2014 SP3 安全更新程序 (KB4505218)
https://www.microsoft.com/zh-cn/download/details.aspx?id=58487
b.Jan 12, 2021 Microsoft SQL Server 2014 Service Pack 3 for x64-based Systems (CU 4) (KB4583462)
https://msrc.microsoft.com/update-guide/en-US/vulnerability/CVE-2021-1636
至此补丁完成