Rapid7 Vulnerability & Exploit Database

Microsoft SQL Server SQLi SUSER_SNAME Windows Domain Account Enumeration

Back to Search

Microsoft SQL Server SQLi SUSER_SNAME Windows Domain Account Enumeration



This module can be used to bruteforce RIDs associated with the domain of the SQL Server using the SUSER_SNAME function via Error Based SQL injection. 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. The syntax for injection URLs is: /testing.asp?id=1+and+1=[SQLi];--


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


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_sqli
msf auxiliary(mssql_enum_domain_accounts_sqli) > show actions
msf auxiliary(mssql_enum_domain_accounts_sqli) > set ACTION < action-name >
msf auxiliary(mssql_enum_domain_accounts_sqli) > show options
    ...show and set options...
msf auxiliary(mssql_enum_domain_accounts_sqli) > 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