Vulnerabilities > CVE-2016-7252 - Information Exposure vulnerability in Microsoft SQL Server 2016

047910
CVSS 6.5 - MEDIUM
Attack vector
NETWORK
Attack complexity
LOW
Privileges required
LOW
Confidentiality impact
HIGH
Integrity impact
NONE
Availability impact
NONE
network
low complexity
microsoft
CWE-200
nessus

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
Microsoft
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_idMS16-136
bulletin_url
date2016-11-08T00:00:00
impactElevation of Privilege
knowledgebase_id3199641
knowledgebase_url
severityImportant
titleSecurity Update for SQL Server

Nessus

  • NASL familyWindows : Microsoft Bulletins
    NASL idSMB_NT_MS16-136.NASL
    descriptionThe 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 seen2020-06-01
    modified2020-06-02
    plugin id94637
    published2016-11-08
    reporterThis script is Copyright (C) 2016-2019 and is owned by Tenable, Inc. or an Affiliate thereof.
    sourcehttps://www.tenable.com/plugins/nessus/94637
    titleMS16-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 familyWindows
    NASL idSMB_KB3199641.NASL
    descriptionThe 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 seen2020-06-01
    modified2020-06-02
    plugin id122484
    published2019-02-28
    reporterThis script is Copyright (C) 2019 and is owned by Tenable, Inc. or an Affiliate thereof.
    sourcehttps://www.tenable.com/plugins/nessus/122484
    titleMS16-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);