Microsoft SQL Server Escalate EXECUTE AS - Metasploit
This page contains detailed information about how to use the auxiliary/admin/mssql/mssql_escalate_execute_as metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.
Module Overview
Name: Microsoft SQL Server Escalate EXECUTE AS
Module: auxiliary/admin/mssql/mssql_escalate_execute_as
Source code: modules/auxiliary/admin/mssql/mssql_escalate_execute_as.rb
Disclosure date: -
Last modification time: 2020-09-22 02:56:51 +0000
Supported architecture(s): -
Supported platform(s): -
Target service / protocol: ms-sql2000, ms-sql-s, sybase
Target network port(s): 1433, 1434, 1435, 2533, 2638, 9152, 14330
List of CVEs: -
This module can be used escalate privileges if the IMPERSONATION privilege has been assigned to the user. In most cases, this results in additional data access, but in some cases it can be used to gain sysadmin privileges.
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
msf auxiliary(mssql_escalate_execute_as) > show targets
... a list of targets ...
msf auxiliary(mssql_escalate_execute_as) > set TARGET target-id
msf auxiliary(mssql_escalate_execute_as) > show options
... show and set options ...
msf auxiliary(mssql_escalate_execute_as) > 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 auxiliary module looks in the msfconsole:
msf6 > use auxiliary/admin/mssql/mssql_escalate_execute_as
msf6 auxiliary(admin/mssql/mssql_escalate_execute_as) > show info
Name: Microsoft SQL Server Escalate EXECUTE AS
Module: auxiliary/admin/mssql/mssql_escalate_execute_as
License: Metasploit Framework License (BSD)
Rank: Normal
Provided by:
nullbind <[email protected]>
Check supported:
No
Basic options:
Name Current Setting Required Description
---- --------------- -------- -----------
PASSWORD no The password for the specified username
RHOSTS yes The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
RPORT 1433 yes The target port (TCP)
TDSENCRYPTION false yes Use TLS/SSL for TDS data "Force Encryption"
USERNAME sa no The username to authenticate as
USE_WINDOWS_AUTHENT false yes Use windows authentification (requires DOMAIN option set)
Description:
This module can be used escalate privileges if the IMPERSONATION
privilege has been assigned to the user. In most cases, this results
in additional data access, but in some cases it can be used to gain
sysadmin privileges.
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 auxiliary module:
msf6 auxiliary(admin/mssql/mssql_escalate_execute_as) > show options
Module options (auxiliary/admin/mssql/mssql_escalate_execute_as):
Name Current Setting Required Description
---- --------------- -------- -----------
PASSWORD no The password for the specified username
RHOSTS yes The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
RPORT 1433 yes The target port (TCP)
TDSENCRYPTION false yes Use TLS/SSL for TDS data "Force Encryption"
USERNAME sa no The username to authenticate as
USE_WINDOWS_AUTHENT false yes Use windows authentification (requires DOMAIN option set)
Advanced Options
Here is a complete list of advanced options supported by the admin/mssql/mssql_escalate_execute_as auxiliary module:
msf6 auxiliary(admin/mssql/mssql_escalate_execute_as) > show advanced
Module advanced options (auxiliary/admin/mssql/mssql_escalate_execute_as):
Name Current Setting Required Description
---- --------------- -------- -----------
CHOST no The local client address
CPORT no The local client port
ConnectTimeout 10 yes Maximum number of seconds to establish a TCP connection
DOMAIN WORKSTATION yes The domain to use for windows authentication
HEX2BINARY /opt/metasploit-framework/embedded/framework/data/exploits/mssql/h2b no The path to the hex2binary script on the disk
NTLM::SendLM true yes Always send the LANMAN response (except when NTLMv2_session is specified)
NTLM::SendNTLM true yes Activate the 'Negotiate NTLM key' flag, indicating the use of NTLM responses
NTLM::SendSPN true yes Send an avp of type SPN in the ntlmv2 client blob, this allows authentication on Windows 7+/Server 2008 R2+ when SPN is required
NTLM::UseLMKey false yes Activate the 'Negotiate Lan Manager Key' flag, using the LM key when the LM response is sent
NTLM::UseNTLM2_session true yes Activate the 'Negotiate NTLM2 key' flag, forcing the use of a NTLMv2_session
NTLM::UseNTLMv2 true yes Use NTLMv2 instead of NTLM2_session when 'Negotiate NTLM2' key is true
Proxies no A proxy chain of format type:host:port[,type:host:port][...]
SSL false no Negotiate SSL/TLS for outgoing connections
SSLCipher no String for SSL cipher - "DHE-RSA-AES256-SHA" or "ADH"
SSLVerifyMode PEER no SSL verification method (Accepted: CLIENT_ONCE, FAIL_IF_NO_PEER_CERT, NONE, PEER)
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)
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 module can do:
msf6 auxiliary(admin/mssql/mssql_escalate_execute_as) > 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 auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):
msf6 auxiliary(admin/mssql/mssql_escalate_execute_as) > show evasion
Module evasion options:
Name Current Setting Required Description
---- --------------- -------- -----------
TCP::max_send_size 0 no Maxiumum tcp segment size. (0 = disable)
TCP::send_delay 0 no Delays inserted before every send. (0 = disable)
Go back to menu.
Error Messages
This module may fail with the following error messages:
- Login was unsuccessful. Check your credentials.
- You're NOT a sysadmin, let's try to change that.
- Sorry, the current user doesn't have permissions to impersonate anyone.
- Sorry, none of the users that can be impersonated are sysadmins.
- Fail buckets, something went wrong.
- Error while trying to escalate privileges.
- <IMP_USER:0> is NOT sysadmin!
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.
Login was unsuccessful. Check your credentials.
Here is a relevant code snippet related to the "Login was unsuccessful. Check your credentials." error message:
25: # Check connection and issue initial query
26: print_status("Attempting to connect to the database server at #{rhost}:#{rport} as #{datastore['USERNAME']}...")
27: if mssql_login_datastore
28: print_good('Connected.')
29: else
30: print_error('Login was unsuccessful. Check your credentials.')
31: disconnect
32: return
33: end
34:
35: # Query for sysadmin status
You're NOT a sysadmin, let's try to change that.
Here is a relevant code snippet related to the "You're NOT a sysadmin, let's try to change that." error message:
40: if user_status == 1
41: print_good("#{datastore['USERNAME']} has the sysadmin role, no escalation required.")
42: disconnect
43: return
44: else
45: print_status("You're NOT a sysadmin, let's try to change that.")
46: end
47:
48: # Get a list of the users that can be impersonated
49: print_status("Enumerating a list of users that can be impersonated...")
50: imp_user_list = check_imp_users
Sorry, the current user doesn't have permissions to impersonate anyone.
Here is a relevant code snippet related to the "Sorry, the current user doesn't have permissions to impersonate anyone." error message:
47:
48: # Get a list of the users that can be impersonated
49: print_status("Enumerating a list of users that can be impersonated...")
50: imp_user_list = check_imp_users
51: if imp_user_list.nil? || imp_user_list.length == 0
52: print_error('Sorry, the current user doesn\'t have permissions to impersonate anyone.')
53: disconnect
54: return
55: else
56: # Display list of users that can be impersonated
57: print_good("#{imp_user_list.length} users can be impersonated:")
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:
62:
63: # Check if any of the users that can be impersonated are sysadmins
64: print_status('Checking if any of them are sysadmins...')
65: imp_user_sysadmin = check_imp_sysadmin(imp_user_list)
66: if imp_user_sysadmin.nil?
67: print_error('Sorry, none of the users that can be impersonated are sysadmins.')
68: disconnect
69: return
70: end
71:
72: # Attempt to escalate to sysadmin
Fail buckets, something went wrong.
Here is a relevant code snippet related to the "Fail buckets, something went wrong." error message:
76: # Check if escalation was successful
77: user_status = check_sysadmin
78: if user_status == 1
79: print_good("Congrats, #{datastore['USERNAME']} is now a sysadmin!.")
80: else
81: print_error('Fail buckets, something went wrong.')
82: end
83: else
84: print_error('Error while trying to escalate privileges.')
85: end
86:
Error while trying to escalate privileges.
Here is a relevant code snippet related to the "Error while trying to escalate privileges." error message:
79: print_good("Congrats, #{datastore['USERNAME']} is now a sysadmin!.")
80: else
81: print_error('Fail buckets, something went wrong.')
82: end
83: else
84: print_error('Error while trying to escalate privileges.')
85: end
86:
87: disconnect
88: return
89: end
<IMP_USER:0> is NOT sysadmin!
Here is a relevant code snippet related to the "<IMP_USER:0> is NOT sysadmin!" error message:
134: status = parse_results[0][0]
135: if status == 1
136: print_good(" - #{imp_user[0]} is a sysadmin!")
137: return imp_user
138: else
139: print_status(" - #{imp_user[0]} is NOT sysadmin!")
140: end
141: end
142: nil
143: end
144:
Go back to menu.
Related Pull Requests
- #14202 Merged Pull Request: Implement the zeitwerk autoloader within lib/msf/core
- #8716 Merged Pull Request: Print_Status -> Print_Good (And OCD bits 'n bobs)
- #8338 Merged Pull Request: Fix msf/core and self.class msftidy warnings
- #6655 Merged Pull Request: use MetasploitModule as a class name
- #6648 Merged Pull Request: Change metasploit class names
- #4325 Merged Pull Request: Minor title change for mssql_enum_domain_accounts_sqli
- #4201 Merged Pull Request: Minor typos and grammar fixes (release fixup)
References
See Also
Check also the following modules related to this module:
- auxiliary/admin/mssql/mssql_enum
- auxiliary/admin/mssql/mssql_enum_domain_accounts
- auxiliary/admin/mssql/mssql_enum_domain_accounts_sqli
- auxiliary/admin/mssql/mssql_enum_sql_logins
- auxiliary/admin/mssql/mssql_escalate_dbowner
- auxiliary/admin/mssql/mssql_escalate_dbowner_sqli
- auxiliary/admin/mssql/mssql_escalate_execute_as_sqli
- auxiliary/admin/mssql/mssql_exec
- auxiliary/admin/mssql/mssql_findandsampledata
- auxiliary/admin/mssql/mssql_idf
- auxiliary/admin/mssql/mssql_ntlm_stealer
- auxiliary/admin/mssql/mssql_ntlm_stealer_sqli
- auxiliary/admin/mssql/mssql_sql
- auxiliary/admin/mssql/mssql_sql_file
- auxiliary/scanner/mssql/mssql_hashdump
- auxiliary/scanner/mssql/mssql_login
- auxiliary/scanner/mssql/mssql_ping
- auxiliary/scanner/mssql/mssql_schemadump
- exploit/windows/mssql/mssql_clr_payload
- exploit/windows/mssql/mssql_linkcrawler
- exploit/windows/mssql/mssql_payload
- exploit/windows/mssql/mssql_payload_sqli
- post/windows/gather/credentials/mssql_local_hashdump
- post/windows/manage/mssql_local_auth_bypass
- exploit/windows/mssql/lyris_listmanager_weak_pass
- exploit/windows/mssql/ms02_039_slammer
- exploit/windows/mssql/ms02_056_hello
- exploit/windows/mssql/ms09_004_sp_replwritetovarbin
- exploit/windows/mssql/ms09_004_sp_replwritetovarbin_sqli
- auxiliary/server/capture/mssql
- payload/osx/armle/execute/bind_tcp
- payload/osx/armle/execute/reverse_tcp
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.