Vulnerabilities > CVE-2016-7252 - Information Exposure vulnerability in Microsoft SQL Server 2016
Attack vector
NETWORK Attack complexity
LOW Privileges required
SINGLE Confidentiality impact
PARTIAL Integrity impact
NONE Availability impact
NONE Summary
Microsoft SQL Server 2016 mishandles the FILESTREAM path, which allows remote authenticated users to gain privileges via unspecified vectors, aka "SQL Analysis Services Information Disclosure Vulnerability."
Vulnerable Configurations
Part | Description | Count |
---|---|---|
Application | 1 |
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.
Msbulletin
bulletin_id | MS16-136 |
bulletin_url | |
date | 2016-11-08T00:00:00 |
impact | Elevation of Privilege |
knowledgebase_id | 3199641 |
knowledgebase_url | |
severity | Important |
title | Security Update for SQL Server |
Nessus
NASL family Windows : Microsoft Bulletins NASL id SMB_NT_MS16-136.NASL description The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by multiple vulnerabilities : - Multiple elevation of privilege vulnerabilities exist in the SQL RDBMS Engine due to improper handling of pointer casting. An authenticated, remote attacker can exploit these to gain elevated privileges. (CVE-2016-7249, CVE-2016-7250, CVE-2016-7254) - A cross-site scripting (XSS) vulnerability exists in the SQL server MDS API due to improper validation of a request parameter on the SQL server site. An unauthenticated, remote attacker can exploit this, via a specially crafted request, to execute arbitrary code in the user last seen 2020-06-01 modified 2020-06-02 plugin id 94637 published 2016-11-08 reporter This script is Copyright (C) 2016-2019 and is owned by Tenable, Inc. or an Affiliate thereof. source https://www.tenable.com/plugins/nessus/94637 title MS16-136: Security Update for SQL Server (3199641) code # # (C) Tenable Network Security, Inc. # include("compat.inc"); if (description) { script_id(94637); script_version("1.12"); script_cvs_date("Date: 2019/11/14"); script_cve_id( "CVE-2016-7249", "CVE-2016-7250", "CVE-2016-7251", "CVE-2016-7252", "CVE-2016-7253", "CVE-2016-7254" ); script_bugtraq_id( 94037, 94043, 94050, 94056, 94060, 94061 ); script_xref(name:"MSFT", value:"MS16-136"); script_xref(name:"MSKB", value:"3194714"); script_xref(name:"MSKB", value:"3194716"); script_xref(name:"MSKB", value:"3194717"); script_xref(name:"MSKB", value:"3194718"); script_xref(name:"MSKB", value:"3194719"); script_xref(name:"MSKB", value:"3194720"); script_xref(name:"MSKB", value:"3194721"); script_xref(name:"MSKB", value:"3194722"); script_xref(name:"MSKB", value:"3194724"); script_xref(name:"MSKB", value:"3194725"); script_name(english:"MS16-136: Security Update for SQL Server (3199641)"); script_summary(english:"Determines the version of the SQL Server."); script_set_attribute(attribute:"synopsis", value: "The remote SQL server is affected by multiple vulnerabilities."); script_set_attribute(attribute:"description", value: "The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by multiple vulnerabilities : - Multiple elevation of privilege vulnerabilities exist in the SQL RDBMS Engine due to improper handling of pointer casting. An authenticated, remote attacker can exploit these to gain elevated privileges. (CVE-2016-7249, CVE-2016-7250, CVE-2016-7254) - A cross-site scripting (XSS) vulnerability exists in the SQL server MDS API due to improper validation of a request parameter on the SQL server site. An unauthenticated, remote attacker can exploit this, via a specially crafted request, to execute arbitrary code in the user's browser session. (CVE-2016-7251) - An information disclosure vulnerability exists in Microsoft SQL Analysis Services due to improper validation of the FILESTREAM path. An authenticated, remote attacker can exploit this to disclose sensitive database and file information. (CVE-2016-7252) - An elevation of privilege vulnerability exists in the Microsoft SQL Server Engine due to improper checking by the SQL Server Agent of ACLs on atxcore.dll. An authenticated, remote attacker can exploit this to gain elevated privileges. (CVE-2016-7253)"); # https://docs.microsoft.com/en-us/security-updates/SecurityBulletins/2016/ms16-136 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?7fef1e99"); 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:S/C:P/I:P/A:P"); 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:L/UI:N/S:U/C:H/I:H/A:H"); script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C"); script_set_attribute(attribute:"cvss_score_source", value:"CVE-2016-7254"); 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:"2016/11/08"); script_set_attribute(attribute:"patch_publication_date", value:"2016/11/08"); script_set_attribute(attribute:"plugin_publication_date", value:"2016/11/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) 2016-2019 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"); script_require_keys("SMB/MS_Bulletin_Checks/Possible"); script_require_ports(139, 445, 1433, "Services/mssql", "Host/patch_management_checks"); exit(0); } include("audit.inc"); 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 = 'MS16-136'; kbs = make_list( "3194714", "3194716", "3194717", "3194718", "3194719", "3194720", "3194721", "3194722", "3194724", "3194725" ); 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); 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 SP2 GDR hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2011.110.5388.0", min_version:"2011.110.5058.0", bulletin:bulletin, kb:'3194719') || # 2012 SP2 CU hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2011.110.5676.0", min_version:"2011.110.5500.0", bulletin:bulletin, kb:'3194725') || # 2012 SP3 GDR hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2011.110.6248.0", min_version:"2011.110.6020.0", bulletin:bulletin, kb:'3194721') || # 2012 SP3 CU hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2011.110.6567.0", min_version:"2011.110.6300.0", bulletin:bulletin, kb:'3194724') || # 2014 SP1 GDR hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2014.120.4232.0", min_version:"2014.120.4100.0", bulletin:bulletin, kb:'3194720') || # 2014 SP1 CU hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2014.120.4487.0", min_version:"2014.120.4400.0", bulletin:bulletin, kb:'3194722') || # 2014 SP2 GDR hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2014.120.5203.0", min_version:"2014.120.5000.0", bulletin:bulletin, kb:'3194714') || # 2014 SP2 CU hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2014.120.5532.0", min_version:"2014.120.5400.0", bulletin:bulletin, kb:'3194718') || # 2016 GDR hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2015.130.1722.0", min_version:"2015.130.1601.5", bulletin:bulletin, kb:'3194716') || # 2016 CU hotfix_is_vulnerable(path:sqlpath, file:"sqlservr.exe", version:"2015.130.2186.6", min_version:"2015.130.2100.0", bulletin:bulletin, kb:'3194717') ) { vuln++; } } hotfix_check_fversion_end(); if (vuln) { set_kb_item(name:'www/0/XSS', value:TRUE); # CVE-2016-7251 set_kb_item(name:"SMB/Missing/"+bulletin, value:TRUE); hotfix_security_warning(); exit(0); } audit(AUDIT_HOST_NOT, 'affected');
NASL family Windows NASL id SMB_KB3199641.NASL description The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by multiple vulnerabilities : - Multiple elevation of privilege vulnerabilities exist in the SQL RDBMS Engine due to improper handling of pointer casting. An authenticated, remote attacker can exploit these to gain elevated privileges. (CVE-2016-7249, CVE-2016-7250, CVE-2016-7254) - A cross-site scripting (XSS) vulnerability exists in the SQL server MDS API due to improper validation of a request parameter on the SQL server site. An unauthenticated, remote attacker can exploit this, via a specially crafted request, to execute arbitrary code in the user last seen 2020-06-01 modified 2020-06-02 plugin id 122484 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/122484 title MS16-136: Security Update for SQL Server (3199641) (uncredentialed check) code # # (C) Tenable Network Security, Inc. # include("compat.inc"); if (description) { script_id(122484); script_version("1.2"); script_cvs_date("Date: 2019/10/31 15:18:52"); script_cve_id( "CVE-2016-7249", "CVE-2016-7250", "CVE-2016-7251", "CVE-2016-7252", "CVE-2016-7253", "CVE-2016-7254" ); script_bugtraq_id( 94037, 94043, 94050, 94056, 94060, 94061 ); script_xref(name:"MSFT", value:"MS16-136"); script_xref(name:"MSKB", value:"3194714"); script_xref(name:"MSKB", value:"3194716"); script_xref(name:"MSKB", value:"3194717"); script_xref(name:"MSKB", value:"3194718"); script_xref(name:"MSKB", value:"3194719"); script_xref(name:"MSKB", value:"3194720"); script_xref(name:"MSKB", value:"3194721"); script_xref(name:"MSKB", value:"3194722"); script_xref(name:"MSKB", value:"3194724"); script_xref(name:"MSKB", value:"3194725"); script_name(english:"MS16-136: Security Update for SQL Server (3199641) (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 multiple vulnerabilities."); script_set_attribute(attribute:"description", value: "The remote Microsoft SQL Server is missing a security update. It is, therefore, affected by multiple vulnerabilities : - Multiple elevation of privilege vulnerabilities exist in the SQL RDBMS Engine due to improper handling of pointer casting. An authenticated, remote attacker can exploit these to gain elevated privileges. (CVE-2016-7249, CVE-2016-7250, CVE-2016-7254) - A cross-site scripting (XSS) vulnerability exists in the SQL server MDS API due to improper validation of a request parameter on the SQL server site. An unauthenticated, remote attacker can exploit this, via a specially crafted request, to execute arbitrary code in the user's browser session. (CVE-2016-7251) - An information disclosure vulnerability exists in Microsoft SQL Analysis Services due to improper validation of the FILESTREAM path. An authenticated, remote attacker can exploit this to disclose sensitive database and file information. (CVE-2016-7252) - An elevation of privilege vulnerability exists in the Microsoft SQL Server Engine due to improper checking by the SQL Server Agent of ACLs on atxcore.dll. An authenticated, remote attacker can exploit this to gain elevated privileges. (CVE-2016-7253)"); # https://docs.microsoft.com/en-us/security-updates/SecurityBulletins/2016/ms16-136 script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?7fef1e99"); 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:S/C:P/I:P/A:P"); 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:L/UI:N/S:U/C:H/I:H/A:H"); script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C"); script_set_attribute(attribute:"cvss_score_source", value:"CVE-2016-7254"); script_set_attribute(attribute:"exploitability_ease", value:"No known exploits are available"); script_set_attribute(attribute:"vuln_publication_date", value:"2016/11/08"); script_set_attribute(attribute:"patch_publication_date", value:"2016/11/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 ( ver_compare(minver:"11.0.5058.0", ver:ver, fix:"11.0.5388.0", strict:FALSE) < 0 || # 2012 SP2 GDR ver_compare(minver:"11.0.5500.0", ver:ver, fix:"11.0.5676.0", strict:FALSE) < 0 || # 2012 SP2 CU ver_compare(minver:"11.0.6020.0", ver:ver, fix:"11.0.6248.0", strict:FALSE) < 0 || # 2012 SP3 GDR ver_compare(minver:"11.0.6300.0", ver:ver, fix:"11.0.6567.0", strict:FALSE) < 0 || # 2012 SP3 CU ver_compare(minver:"12.0.4100.0", ver:ver, fix:"12.0.4232.0", strict:FALSE) < 0 || # 2014 SP1 GDR ver_compare(minver:"12.0.4400.0", ver:ver, fix:"12.0.4487.0", strict:FALSE) < 0 || # 2014 SP1 CU ver_compare(minver:"12.0.5000.0", ver:ver, fix:"12.0.5203.0", strict:FALSE) < 0 || # 2014 SP2 GDR ver_compare(minver:"12.0.5400.0", ver:ver, fix:"12.0.5532.0", strict:FALSE) < 0 || # 2014 SP2 CU ver_compare(minver:"13.0.1601.0", ver:ver, fix:"13.0.1722.0", strict:FALSE) < 0 || # 2016 GDR ver_compare(minver:"13.0.2100.0", ver:ver, fix:"13.0.2186.0", strict:FALSE) < 0 # 2016 CU ) { 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);