The assessment demonstrated abuse of xp_cmdshell to execute operating-system commands through Microsoft SQL Server. I addressed and monitored SQL server coverage and built an alert for the parent-child relationship between the SQL Server process and a spawned command shell. This focuses detection on the host execution behaviour associated with the finding.
Viewed
UK Water Utility
Detect SQL Server spawning a command shell
Turn Red Team findings into detection and hardening
Return to the full story ←