OpenCanary - MSSQL Login Attempt Via SQLAuth — Sigma Rule

Rule metadata and linked tags

Author: Security Onion Solutions. Source status: test; severity: high. Source dates: 2024-03-08 / not supplied.

{
  "category": "application",
  "product": "opencanary"
}

Pinned original Sigma rule · Detection Rule License 1.1

Source SHA-256: c7a487c13249524c003f39e2a17c739f22cae2c2983c441835ae7e1457b23365

Detection logic

Original source YAML. Source-tag agreement is not proof of complete semantic coverage. This rule has not been compiled for a SIEM backend or validated against live telemetry here.

title: OpenCanary - MSSQL Login Attempt Via SQLAuth
id: 3ec9a16d-0b4f-4967-9542-ebf38ceac7dd
status: test
description: |
    Detects instances where an MSSQL service on an OpenCanary node has had a login attempt using SQLAuth.
references:
    - https://opencanary.readthedocs.io/en/latest/starting/configuration.html#services-configuration
    - https://github.com/thinkst/opencanary/blob/a0896adfcaf0328cfd5829fe10d2878c7445138e/opencanary/logger.py#L52
author: Security Onion Solutions
date: 2024-03-08
tags:
    - attack.credential-access
    - attack.collection
    - attack.t1003
    - attack.t1213
logsource:
    category: application
    product: opencanary
detection:
    selection:
        logtype: 9001
    condition: selection
falsepositives:
    - Unlikely
level: high

Original YAML and metadata in JSON

False positives

• Unlikely

Source references

• https://opencanary.readthedocs.io/en/latest/starting/configuration.html#services-configuration
• https://github.com/thinkst/opencanary/blob/a0896adfcaf0328cfd5829fe10d2878c7445138e/opencanary/logger.py#L52