Microsoft SQL Server Interesting Data Finder - Metasploit


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

Table Of Contents
hide

Module Overview

Name: Microsoft SQL Server Interesting Data Finder
Module: auxiliary/admin/mssql/mssql_idf
Source code: modules/auxiliary/admin/mssql/mssql_idf.rb
Disclosure date: -
Last modification time: 2021-04-22 10:15:04 +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 search the specified MSSQL server for 'interesting' columns and data. This module has been tested against the latest SQL Server 2019 docker container image (22/04/2021).

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_idf
msf auxiliary(mssql_idf) > show targets
    ... a list of targets ...
msf auxiliary(mssql_idf) > set TARGET target-id
msf auxiliary(mssql_idf) > show options
    ... show and set options ...
msf auxiliary(mssql_idf) > exploit

Required Options

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

Knowledge Base

Description

This (Interesting Data Finder) module will connect to a remote MSSQL server using a given set of credentials and search for rows and columns with "interesting" names. This information can help you fine-tune further attacks against the database.

Verification Steps

  1. Do: use auxiliary/admin/mssql/mssql_idf
  2. Do: set RHOSTS [IP]
  3. Do: set THREADS [number of threads]
  4. Do: run

Scenarios

msf > use auxiliary/admin/mssql/mssql_idf
msf auxiliary(mssql_idf) > set NAMES username|password
NAMES => username|password
msf auxiliary(mssql_idf) > set PASSWORD password1
PASSWORD => password1
msf auxiliary(mssql_idf) > set RHOST 192.168.1.195
RHOST => 192.168.1.195
msf auxiliary(mssql_idf) > run


Database Schema Table          Column                Data Type Row Count 

======== ====== ============== ===================== ========= ========= ======== ====== ============== ===================== ========= ========= 

msdb     dbo    sysmail_server username              nvarchar  0

msdb     dbo    backupmediaset is_password_protected bit       0

msdb     dbo    backupset      is_password_protected bit       0

logins   dbo    userpass       username              varchar   3

logins   dbo    userpass       password              varchar   3


[*] Auxiliary module execution completed
msf auxiliary(mssql_idf) >

Go back to menu.

Msfconsole Usage

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

msf6 > use auxiliary/admin/mssql/mssql_idf

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

       Name: Microsoft SQL Server Interesting Data Finder
     Module: auxiliary/admin/mssql/mssql_idf
    License: Metasploit Framework License (BSD)
       Rank: Normal

Provided by:
  Robin Wood <[email protected]>

Check supported:
  No

Basic options:
  Name                 Current Setting         Required  Description
  ----                 ---------------         --------  -----------
  NAMES                passw|bank|credit|card  yes       Pipe separated list of column names
  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 will search the specified MSSQL server for 'interesting' 
  columns and data. This module has been tested against the latest SQL 
  Server 2019 docker container image (22/04/2021).

References:
  http://www.digininja.org/metasploit/mssql_idf.php

Module Options

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

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

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

   Name                 Current Setting         Required  Description
   ----                 ---------------         --------  -----------
   NAMES                passw|bank|credit|card  yes       Pipe separated list of column names
   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_idf auxiliary module:

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

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

   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_idf module can do:

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

Auxiliary actions:

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

Evasion Options

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

msf6 auxiliary(admin/mssql/mssql_idf) > 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:

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.

Login failed

Here is a relevant code snippet related to the "Login failed" error message:

87:	
88:	    begin
89:	      if mssql_login_datastore
90:	        result = mssql_query(sql, false)
91:	      else
92:	        print_error('Login failed')
93:	        return
94:	      end
95:	    rescue Rex::ConnectionRefused => e
96:	      print_error("Connection failed: #{e}")
97:	      return

Connection failed: <E>

Here is a relevant code snippet related to the "Connection failed: <E>" error message:

91:	      else
92:	        print_error('Login failed')
93:	        return
94:	      end
95:	    rescue Rex::ConnectionRefused => e
96:	      print_error("Connection failed: #{e}")
97:	      return
98:	    end
99:	
100:	    column_data = result[:rows]
101:	    widths = [0, 0, 0, 0, 0, 9]

No columns matched the pattern <VALUE>. Set the NAMES option to change this search pattern.

Here is a relevant code snippet related to the "No columns matched the pattern <VALUE>. Set the NAMES option to change this search pattern." error message:

100:	    column_data = result[:rows]
101:	    widths = [0, 0, 0, 0, 0, 9]
102:	    total_width = 0
103:	
104:	    if column_data.nil?
105:	      print_error("No columns matched the pattern #{datastore['NAMES'].inspect}. Set the NAMES option to change this search pattern.")
106:	      return
107:	    end
108:	
109:	    (column_data|headings).each { |row|
110:	      0.upto(4) { |col|

Go back to menu.

References

See Also

Check also the following modules related to this module:

Authors

  • Robin Wood <robin[at]digininja.org>

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.