How to identify and crack an MSSQL (2005) hash

MSSQL (2005) is an database hash type. It is fast and typically unsalted, which makes weak passwords recoverable quickly on consumer GPU hardware. This page shows how to recognise it and the exact commands to attack it.

All identification runs locally in WebAssembly. The commands below write the hash to a local file on your machine — nothing is sent to this site.

Identifying the hash

The hash identifier on the home page detects MSSQL (2005) entirely in your browser — your hash is never uploaded. A typical example looks like this:

0x010040866ceb6bf8cc2e6f6d6c4f5fabe6cae0a45f6f5e8a

Cracking MSSQL (2005) with hashcat

Save the hash to a file and run hashcat in mode -m 132. Start with a wordlist such as rockyou.txt:

echo '0x010040866ceb6bf8cc2e6f6d6c4f5fabe6cae0a45f6f5e8a' > hash.txt && hashcat -m 132 hash.txt /usr/share/wordlists/rockyou.txt

Add a rule set to mutate dictionary words (capitalisation, leetspeak, appended digits) and dramatically widen coverage:

echo '0x010040866ceb6bf8cc2e6f6d6c4f5fabe6cae0a45f6f5e8a' > hash.txt && hashcat -m 132 hash.txt /usr/share/wordlists/rockyou.txt -r /usr/share/hashcat/rules/best64.rule

Cracking MSSQL (2005) with John the Ripper

John the Ripper can attack the same hash with the mssql05 format:

echo '0x010040866ceb6bf8cc2e6f6d6c4f5fabe6cae0a45f6f5e8a' > hash.txt && john --format=mssql05 --wordlist=/usr/share/wordlists/rockyou.txt hash.txt