Vulnerabilities > CVE-2017-8516 - Information Exposure vulnerability in Microsoft SQL Server 2012/2014/2016

047910
CVSS 7.5 - HIGH
Attack vector
NETWORK
Attack complexity
LOW
Privileges required
NONE
Confidentiality impact
HIGH
Integrity impact
NONE
Availability impact
NONE
network
low complexity
microsoft
CWE-200
nessus
NVD
Published: 2017-08-08
Updated: 2022-10-27

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
Microsoft
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 familyWindows
    NASL idSMB_NT_MS17_AUG_MSSQL_REMOTE.NASL
    descriptionThe 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 seen2020-06-01
    modified2020-06-02
    plugin id122485
    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/122485
    titleKB4036996: 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 familyWindows : Microsoft Bulletins
    NASL idSMB_NT_MS17_AUG_MSSQL.NASL
    descriptionThe 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 seen2020-05-12
    modified2017-08-08
    plugin id102271
    published2017-08-08
    reporterThis script is Copyright (C) 2017-2020 and is owned by Tenable, Inc. or an Affiliate thereof.
    sourcehttps://www.tenable.com/plugins/nessus/102271
    titleKB4036996: 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