Vulnerabilities > CVE-2017-8516 - Information Exposure vulnerability in Microsoft SQL Server 2012/2014/2016
Attack vector
NETWORK Attack complexity
LOW Privileges required
NONE Confidentiality impact
HIGH Integrity impact
NONE Availability impact
NONE Summary
Microsoft SQL Server Analysis Services in Microsoft SQL Server 2012, Microsoft SQL Server 2014, and Microsoft SQL Server 2016 allows an information disclosure vulnerability when it improperly enforces permissions, aka "Microsoft SQL Server Analysis Services Information Disclosure Vulnerability".
Vulnerable Configurations
| Part | Description | Count |
|---|---|---|
| Application | 5 |
Common Weakness Enumeration (CWE)
Common Attack Pattern Enumeration and Classification (CAPEC)
- Subverting Environment Variable Values The attacker directly or indirectly modifies environment variables used by or controlling the target software. The attacker's goal is to cause the target software to deviate from its expected operation in a manner that benefits the attacker.
- Footprinting An attacker engages in probing and exploration activity to identify constituents and properties of the target. Footprinting is a general term to describe a variety of information gathering techniques, often used by attackers in preparation for some attack. It consists of using tools to learn as much as possible about the composition, configuration, and security mechanisms of the targeted application, system or network. Information that might be collected during a footprinting effort could include open ports, applications and their versions, network topology, and similar information. While footprinting is not intended to be damaging (although certain activities, such as network scans, can sometimes cause disruptions to vulnerable applications inadvertently) it may often pave the way for more damaging attacks.
- Exploiting Trust in Client (aka Make the Client Invisible) An attack of this type exploits a programs' vulnerabilities in client/server communication channel authentication and data integrity. It leverages the implicit trust a server places in the client, or more importantly, that which the server believes is the client. An attacker executes this type of attack by placing themselves in the communication channel between client and server such that communication directly to the server is possible where the server believes it is communicating only with a valid client. There are numerous variations of this type of attack.
- Browser Fingerprinting An attacker carefully crafts small snippets of Java Script to efficiently detect the type of browser the potential victim is using. Many web-based attacks need prior knowledge of the web browser including the version of browser to ensure successful exploitation of a vulnerability. Having this knowledge allows an attacker to target the victim with attacks that specifically exploit known or zero day weaknesses in the type and version of the browser used by the victim. Automating this process via Java Script as a part of the same delivery system used to exploit the browser is considered more efficient as the attacker can supply a browser fingerprinting method and integrate it with exploit code, all contained in Java Script and in response to the same web page request by the browser.
- Session Credential Falsification through Prediction This attack targets predictable session ID in order to gain privileges. The attacker can predict the session ID used during a transaction to perform spoofing and session hijacking.
Nessus
NASL family Windows NASL id SMB_NT_MS17_AUG_MSSQL_REMOTE.NASL description The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by an information disclosure vulnerability in Microsoft SQL Server Analysis Services when it improperly enforces permissions. An attacker could exploit the vulnerability if the attacker last seen 2020-06-01 modified 2020-06-02 plugin id 122485 published 2019-02-28 reporter This script is Copyright (C) 2019 and is owned by Tenable, Inc. or an Affiliate thereof. source https://www.tenable.com/plugins/nessus/122485 title KB4036996: Security Update for SQL Server (August 2017) (uncredentialed check) code # # (C) Tenable Network Security, Inc. # include("compat.inc"); if (description) { script_id(122485); script_version("1.2"); script_cvs_date("Date: 2019/10/31 15:18:52"); script_cve_id("CVE-2017-8516"); script_bugtraq_id(100041); script_xref(name:"MSKB", value:"4036996"); script_xref(name:"MSFT", value:"MS17-4036996"); script_xref(name:"MSKB", value:"4032542"); script_xref(name:"MSFT", value:"MS17-4032542"); script_xref(name:"MSKB", value:"4019095"); script_xref(name:"MSFT", value:"MS17-4019095"); script_xref(name:"MSKB", value:"4019093"); script_xref(name:"MSFT", value:"MS17-4019093"); script_xref(name:"MSKB", value:"4019092"); script_xref(name:"MSFT", value:"MS17-4019092"); script_xref(name:"MSKB", value:"4019091"); script_xref(name:"MSFT", value:"MS17-4019091"); script_xref(name:"MSKB", value:"4019090"); script_xref(name:"MSFT", value:"MS17-4019090"); script_xref(name:"MSKB", value:"4019089"); script_xref(name:"MSFT", value:"MS17-4019089"); script_xref(name:"MSKB", value:"4019088"); script_xref(name:"MSFT", value:"MS17-4019088"); script_xref(name:"MSKB", value:"4019086"); script_xref(name:"MSFT", value:"MS17-4019086"); script_name(english:"KB4036996: Security Update for SQL Server (August 2017) (uncredentialed check)"); script_summary(english:"Determines the version of the SQL Server."); script_set_attribute(attribute:"synopsis", value: "The remote SQL server is affected by an information disclosure vulnerability."); script_set_attribute(attribute:"description", value: "The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by an information disclosure vulnerability in Microsoft SQL Server Analysis Services when it improperly enforces permissions. An attacker could exploit the vulnerability if the attacker's credentials allow access to an affected SQL server database. An attacker who successfully exploited the vulnerability could gain additional database and file information."); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4036996"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4032542"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019095"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019093"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019092"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019091"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019090"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019089"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019088"); script_set_attribute(attribute:"see_also", value:"https://support.microsoft.com/en-us/help/4019086"); script_set_attribute(attribute:"solution", value: "Microsoft has released a set of patches for SQL Server 2012, 2014, and 2016."); script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:N/C:P/I:N/A:N"); script_set_cvss_temporal_vector("CVSS2#E:U/RL:OF/RC:C"); script_set_cvss3_base_vector("CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N"); script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C"); script_set_attribute(attribute:"cvss_score_source", value:"CVE-2017-8516"); script_set_attribute(attribute:"exploitability_ease", value:"No known exploits are available"); script_set_attribute(attribute:"vuln_publication_date", value:"2017/08/08"); script_set_attribute(attribute:"patch_publication_date", value:"2017/08/08"); script_set_attribute(attribute:"plugin_publication_date", value:"2019/02/28"); script_set_attribute(attribute:"potential_vulnerability", value:"true"); script_set_attribute(attribute:"plugin_type", value:"remote"); script_set_attribute(attribute:"cpe", value:"cpe:/a:microsoft:sql_server"); script_end_attributes(); script_category(ACT_GATHER_INFO); script_family(english:"Windows"); script_copyright(english:"This script is Copyright (C) 2019 and is owned by Tenable, Inc. or an Affiliate thereof."); script_dependencies("mssqlserver_detect.nasl"); script_require_keys("Settings/ParanoidReport"); script_require_ports(1433, "Services/mssql"); exit(0); } include("audit.inc"); include("global_settings.inc"); include("misc_func.inc"); if (report_paranoia < 2) audit(AUDIT_PARANOID); port = get_service(svc:"mssql", exit_on_fail:TRUE); instance = get_kb_item("MSSQL/" + port + "/InstanceName"); version = get_kb_item_or_exit("MSSQL/" + port + "/Version"); ver = pregmatch(pattern:"^([0-9.]+)([^0-9]|$)", string:version); if(!isnull(ver) && !isnull(ver[1])) ver = ver[1]; if ( # 2012 GDR SP3 ver_compare(minver:"11.0.6020.0", ver:ver, fix:"11.0.6251.0", strict:FALSE) < 0 || # 2012 CU SP3 ver_compare(minver:"11.0.6518.0", ver:ver, fix:"11.0.6607.0", strict:FALSE) < 0 || # 2014 GDR SP1 ver_compare(minver:"12.0.4100.0", ver:ver, fix:"12.0.4237.0", strict:FALSE) < 0 || # 2014 CU SP1 ver_compare(minver:"12.0.4416.0", ver:ver, fix:"12.0.4522.0", strict:FALSE) < 0 || # 2014 GDR SP2 ver_compare(minver:"12.0.5000.0", ver:ver, fix:"12.0.5207.0", strict:FALSE) < 0 || # 2014 CU SP2 ver_compare(minver:"12.0.5511.0", ver:ver, fix:"12.0.5553.0", strict:FALSE) < 0 || # 2016 RTM CU ver_compare(minver:"13.0.2149.0", ver:ver, fix:"13.0.2210.0", strict:FALSE) < 0 || # 2016 GDR ver_compare(minver:"13.0.1601.0", ver:ver, fix:"13.0.1742.0", strict:FALSE) < 0 || # 2016 GDR SP1 ver_compare(minver:"13.0.4000.0", ver:ver, fix:"13.0.4206.0", strict:FALSE) < 0 || # 2016 CU SP1 ver_compare(minver:"13.0.4411.0", ver:ver, fix:"13.0.4446.0", strict:FALSE) < 0 ) { report = ''; if(!empty_or_null(version)) report += '\n SQL Server Version : ' + version; if(!empty_or_null(instance)) report += '\n SQL Server Instance : ' + instance; security_report_v4(port:port, extra:report, severity:SECURITY_WARNING); } else audit(AUDIT_INST_VER_NOT_VULN, "MSSQL", version);NASL family Windows : Microsoft Bulletins NASL id SMB_NT_MS17_AUG_MSSQL.NASL description The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by an information disclosure vulnerability in Microsoft SQL Server Analysis Services when it improperly enforces permissions. An attacker could exploit the vulnerability if the attacker last seen 2020-05-12 modified 2017-08-08 plugin id 102271 published 2017-08-08 reporter This script is Copyright (C) 2017-2020 and is owned by Tenable, Inc. or an Affiliate thereof. source https://www.tenable.com/plugins/nessus/102271 title KB4036996: Security Update for SQL Server (August 2017) code # # (C) Tenable Network Security, Inc. # include("compat.inc"); if (description) { script_id(102271); script_version("1.12"); script_set_attribute(attribute:"plugin_modification_date", value:"2020/05/11"); script_cve_id("CVE-2017-8516"); script_bugtraq_id(100041); script_xref(name:"MSKB", value:"4036996"); script_xref(name:"MSFT", value:"MS17-4036996"); script_xref(name:"MSKB", value:"4032542"); script_xref(name:"MSFT", value:"MS17-4032542"); script_xref(name:"MSKB", value:"4019095"); script_xref(name:"MSFT", value:"MS17-4019095"); script_xref(name:"MSKB", value:"4019093"); script_xref(name:"MSFT", value:"MS17-4019093"); script_xref(name:"MSKB", value:"4019092"); script_xref(name:"MSFT", value:"MS17-4019092"); script_xref(name:"MSKB", value:"4019091"); script_xref(name:"MSFT", value:"MS17-4019091"); script_xref(name:"MSKB", value:"4019090"); script_xref(name:"MSFT", value:"MS17-4019090"); script_xref(name:"MSKB", value:"4019089"); script_xref(name:"MSFT", value:"MS17-4019089"); script_xref(name:"MSKB", value:"4019088"); script_xref(name:"MSFT", value:"MS17-4019088"); script_xref(name:"MSKB", value:"4019086"); script_xref(name:"MSFT", value:"MS17-4019086"); script_name(english:"KB4036996: Security Update for SQL Server (August 2017)"); script_summary(english:"Determines the version of the SQL Server."); script_set_attribute(attribute:"synopsis", value: "The remote SQL server is affected by an information disclosure vulnerability."); script_set_attribute(attribute:"description", value: "The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by an information disclosure vulnerability in Microsoft SQL Server Analysis Services when it improperly enforces permissions. An attacker could exploit the vulnerability if the attacker's credentials allow access to an affected SQL server database. An attacker who successfully exploited the vulnerability could gain additional database and file information."); # https://support.microsoft.com/en-us/help/4036996/description-of-the-security-update-for-sql-server-2014-service-pack-2 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?dfd0b897"); # https://support.microsoft.com/en-us/help/4032542/description-of-the-security-update-for-sql-server-2014-service-pack-1 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?36cb4e99"); # https://support.microsoft.com/en-us/help/4019095/description-of-the-security-update-for-sql-server-2016-service-pack-1 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?6f68e083"); # https://support.microsoft.com/en-us/help/4019093/description-of-the-security-update-for-sql-server-2014-service-pack-2 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?9d9d929f"); # https://support.microsoft.com/en-us/help/4019092/description-of-the-security-update-for-sql-server-2012-service-pack-3 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?437909d8"); # https://support.microsoft.com/en-us/help/4019091/description-of-the-security-update-for-sql-server-2014-service-pack-1 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?5cf8885b"); # https://support.microsoft.com/en-us/help/4019090/description-of-the-security-update-for-sql-server-2012-service-pack-3 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?84700f7c"); # https://support.microsoft.com/en-us/help/4019089/description-of-the-security-update-for-sql-server-2016-service-pack-1 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?7d95d0aa"); # https://support.microsoft.com/en-us/help/4019088/description-of-the-security-update-for-sql-server-2016-rtm-gdr-august script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?36082fe7"); # https://support.microsoft.com/en-us/help/4019086/description-of-the-security-update-for-sql-server-2016-rtm-cu-august-8 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?180dfb8a"); script_set_attribute(attribute:"solution", value: "Microsoft has released a set of patches for SQL Server 2012, 2014, and 2016."); script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:N/C:P/I:N/A:N"); script_set_cvss_temporal_vector("CVSS2#E:U/RL:OF/RC:C"); script_set_cvss3_base_vector("CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N"); script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C"); script_set_attribute(attribute:"cvss_score_source", value:"CVE-2017-8516"); script_set_attribute(attribute:"exploitability_ease", value:"No known exploits are available"); script_set_attribute(attribute:"exploit_available", value:"false"); script_set_attribute(attribute:"vuln_publication_date", value:"2017/08/08"); script_set_attribute(attribute:"patch_publication_date", value:"2017/08/08"); script_set_attribute(attribute:"plugin_publication_date", value:"2017/08/08"); script_set_attribute(attribute:"plugin_type", value:"local"); script_set_attribute(attribute:"cpe", value:"cpe:/a:microsoft:sql_server"); script_end_attributes(); script_category(ACT_GATHER_INFO); script_family(english:"Windows : Microsoft Bulletins"); script_copyright(english:"This script is Copyright (C) 2017-2020 and is owned by Tenable, Inc. or an Affiliate thereof."); script_dependencies("smb_hotfixes.nasl", "mssql_version.nasl", "smb_enum_services.nasl", "ms_bulletin_checks_possible.nasl", "smb_enum_softwares.nasl"); script_require_keys("SMB/MS_Bulletin_Checks/Possible"); script_require_ports(139, 445, 1433, "Services/mssql", "Host/patch_management_checks"); exit(0); } include('smb_func.inc'); include('smb_hotfixes.inc'); include('smb_hotfixes_fcheck.inc'); include('misc_func.inc'); get_kb_item_or_exit('SMB/MS_Bulletin_Checks/Possible'); bulletin = 'MS17-08'; kbs = make_list( '4036996', '4032542', '4019095', '4019093', '4019092', '4019091', '4019090', '4019089', '4019088', '4019086' ); if (get_kb_item('Host/patch_management_checks')) hotfix_check_3rd_party(bulletin:bulletin, kbs:kbs, severity:SECURITY_WARNING); get_kb_item_or_exit('SMB/Registry/Enumerated'); get_kb_item_or_exit('SMB/WindowsVersion', exit_code:1); olap = get_kb_item_or_exit('SMB/svc/MSSQLServerOLAPService/display_name', msg:'The host is not vulnerable as Analysis Services are not installed.'); if ('analysis services' >!< tolower(olap)) audit(AUDIT_HOST_NOT, 'vulnerable as Analysis Services are not installed'); ver_list = get_kb_list('mssql/installs/*/SQLVersion'); if (isnull(ver_list)) audit(AUDIT_NOT_INST, 'Microsoft SQL Server'); # Database Services Core Instance foreach item (keys(ver_list)) { item -= 'mssql/installs/'; item -= '/SQLVersion'; sqlpath = item; share = hotfix_path2share(path:sqlpath); if (!is_accessible_share(share:share)) continue; version = get_kb_item('mssql/installs/' + sqlpath + '/SQLVersion'); # continue if not SQL Server 2012, 2014, or 2016 if (version !~ "^11\.0\." && version !~ "^12\.0\." && version !~ "^13\.0\.") continue; sqltype = get_kb_item('mssql/installs/' + sqlpath + '/edition_type'); if (isnull(sqltype)) sqltype = get_kb_item('mssql/installs/' + sqlpath + '/edition'); if ( sqlpath && # 2012 GDR SP3 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2011.110.6251.0', min_version:'2011.110.6020.0', bulletin:bulletin, kb:'4019092') || # 2012 CU SP3 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2011.110.6607.0', min_version:'2011.110.6518.0', bulletin:bulletin, kb:'4019090') || # 2014 GDR SP1 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2014.120.4237.0', min_version:'2014.120.4100.0', bulletin:bulletin, kb:'4019091') || # 2014 CU SP1 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2014.120.4522.0', min_version:'2014.120.4416.0', bulletin:bulletin, kb:'4032542') || # 2014 GDR SP2 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2014.120.5207.0', min_version:'2014.120.5000.0', bulletin:bulletin, kb:'4019093') || # 2014 CU SP2 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2014.120.5553.0', min_version:'2014.120.5511.0', bulletin:bulletin, kb:'4036996') || # 2016 RTM CU hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2015.130.2210.0', min_version:'2015.130.2149.0', bulletin:bulletin, kb:'4019086') || # 2016 GDR hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2015.130.1742.0', min_version:'2015.130.1601.0', bulletin:bulletin, kb:'4019088') || # 2016 GDR SP1 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2015.130.4206.0', min_version:'2015.130.4000.0', bulletin:bulletin, kb:'4019089') || # 2016 CU SP1 hotfix_is_vulnerable(path:sqlpath, file:'sqlservr.exe', version:'2015.130.4446.0', min_version:'2015.130.4411.0', bulletin:bulletin, kb:'4019095') ) { vuln++; } } hotfix_check_fversion_end(); if (vuln) { set_kb_item(name:'SMB/Missing/'+bulletin, value:TRUE); hotfix_security_warning(); exit(0); } audit(AUDIT_HOST_NOT, 'affected');
References
- http://www.securityfocus.com/bid/100041
- http://www.securityfocus.com/bid/100041
- http://www.securitytracker.com/id/1039110
- http://www.securitytracker.com/id/1039110
- https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/CVE-2017-8516
- https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/CVE-2017-8516