Rapid7 Vulnerability & Exploit Database

Microsoft SQL Server SUSER_SNAME Windows Domain Account Enumeration

Back to Search

Microsoft SQL Server SUSER_SNAME Windows Domain Account Enumeration

Created
05/30/2018

Description

This module can be used to bruteforce RIDs associated with the domain of the SQL Server using the SUSER_SNAME function. This is similar to the smb_lookupsid module, but executed through SQL Server queries as any user with the PUBLIC role (everyone). Information that can be enumerated includes Windows domain users, groups, and computer accounts. Enumerated accounts can then be used in online dictionary attacks.

Author(s)

  • nullbind <scott.sutherland@netspi.com>
  • antti <antti.rantasaari@netspi.com>

Development

Module Options

To display the available options, load the module within the Metasploit console and run the commands 'show options' or 'show advanced':

msf > use auxiliary/admin/mssql/mssql_enum_domain_accounts
msf auxiliary(mssql_enum_domain_accounts) > show actions
    ...actions...
msf auxiliary(mssql_enum_domain_accounts) > set ACTION < action-name >
msf auxiliary(mssql_enum_domain_accounts) > show options
    ...show and set options...
msf auxiliary(mssql_enum_domain_accounts) > run 

Time is precious, so I don’t want to do something manually that I can automate. Leveraging the Metasploit Framework when automating any task keeps us from having to re-create the wheel as we can use the existing libraries and focus our efforts where it matters.

– Jim O’Gorman | President, Offensive Security

;