MSSQL Schema Dump

This module attempts to extract the schema from a MSSQL Server Instance. It will disregard builtin and example DBs such as master,model,msdb, and tempdb. The module will create a note for each DB found, and store a YAML formatted output as loot for easy reading.

Search Other Modules

Rank

Normal

Authors

TheLightCosine < thelightcosine [at] gmail.com >

Development

Similar Modules

Usage Information

$ msfconsole

                ##                          ###           ##    ##
##  ##  #### ###### ####  #####   #####    ##    ####        ######
####### ##  ##  ##  ##         ## ##  ##    ##   ##  ##   ###   ##
####### ######  ##  #####   ####  ##  ##    ##   ##  ##   ##    ##
## # ##     ##  ##  ##  ## ##      #####    ##   ##  ##   ##    ##
##   ##  #### ###   #####   #####     ##   ####   ####   #### ###
                                      ##

msf > use auxiliary/scanner/mssql/mssql_schemadump
msf auxiliary(mssql_schemadump) > set RHOSTS [TARGET HOST RANGE]
msf auxiliary(mssql_schemadump) > run

Module Options

DISPLAY_RESULTS	Display the Results to the Screen (default: true)
PASSWORD	The password for the specified username (default: )
RHOSTS	The target address range or CIDR identifier
RPORT	The target port (default: 1433)
THREADS	The number of concurrent threads (default: 1)
USERNAME	The username to authenticate as (default: sa)
USE_WINDOWS_AUTHENT	Use windows authentification (requires DOMAIN option set)
CHOST	The local client address
CPORT	The local client port
ConnectTimeout	Maximum number of seconds to establish a TCP connection
DOMAIN	The domain to use for windows authentication
HEX2BINARY	The path to the hex2binary script on the disk
NTLM::SendLM	Always send the LANMAN response (except when NTLMv2_session is specified)
NTLM::SendNTLM	Activate the 'Negotiate NTLM key' flag, indicating the use of NTLM responses
NTLM::SendSPN	Send an avp of type SPN in the ntlmv2 client Blob, this allow authentification on windows Seven/2008r2 when SPN is required
NTLM::UseLMKey	Activate the 'Negotiate Lan Manager Key' flag, using the LM key when the LM response is sent
NTLM::UseNTLM2_session	Activate the 'Negotiate NTLM2 key' flag, forcing the use of a NTLMv2_session
NTLM::UseNTLMv2	Use NTLMv2 instead of NTLM2_session when 'Negotiate NTLM2' key is true
Proxies	Use a proxy chain
SSL	Negotiate SSL for outgoing connections
SSLVersion	Specify the version of SSL that should be used (accepted: SSL2, SSL3, TLS1)
ShowProgress	Display progress messages during a scan
ShowProgressPercent	The interval in percent that progress should be shown
VERBOSE	Enable detailed status messages
WORKSPACE	Specify the workspace for this module
TCP::max_send_size	Maxiumum tcp segment size. (0 = disable)
TCP::send_delay	Delays inserted before every send. (0 = disable)