Sigma rule: OpenCanary - MSSQL Login Attempt Via Windows Authentication

A detection rule from the SigmaHQ repository, shown as its author published it. Dataset version ref-5bf8deb4f4ca, updated 2024-03-08T00:00:00.000Z.

Rule

Title
OpenCanary - MSSQL Login Attempt Via Windows Authentication
Status
test
Level
high
Author
Security Onion Solutions
Date
2024-03-08
File
rules/application/opencanary/opencanary_mssql_login_winauth.yml
Commit
ccbb0369507f796db0b0ae6854c8a2be471b9d84

Detects instances where an MSSQL service on an OpenCanary node has had a login attempt using Windows Authentication.

Log source

product
opencanary
category
application

Detection

selection:
    logtype: 9002
condition: selection

False positives (as the rule lists them)

  • Unlikely

Tags

  • attack.credential-access
  • attack.collection
  • attack.t1003
  • attack.t1213

MITRE ATT&CK ids this rule names

References

Read on 2026-11-03T00:58:21.399Z under licence sigma-drl-1.1@d5f4c36a from https://github.com/SigmaHQ/sigma/blob/ccbb0369507f796db0b0ae6854c8a2be471b9d84/rules/application/opencanary/opencanary_mssql_login_winauth.yml

Sources and licences

  • SigmaHQ

    "OpenCanary - MSSQL Login Attempt Via Windows Authentication" by Security Onion Solutions (SigmaHQ). Rule: https://github.com/SigmaHQ/sigma/blob/ccbb0369507f796db0b0ae6854c8a2be471b9d84/rules/application/opencanary/opencanary_mssql_login_winauth.yml.
    Licensed under the Detection Rule License (DRL) 1.1: https://github.com/SigmaHQ/Detection-Rule-License

    Detection Rule License (DRL) 1.1

Cite this page

Dragons Eye Ransomware Tracker, "Sigma rule: OpenCanary - MSSQL Login Attempt Via Windows Authentication",
entity page, dataset version ref-5bf8deb4f4ca, updated 2024-03-08T00:00:00.000Z,
https://ransomware-tracker.com/detections/sigma/6e78f90f-0043-4a01-ac41-f97681613a66 (accessed 2026-11-03).
Underlying source: SigmaHQ rule 6e78f90f-0043-4a01-ac41-f97681613a66, commit ccbb0369507f796db0b0ae6854c8a2be471b9d84.

Pages change. The dataset version identifies the data, but no archive of old versions is kept, so this citation cannot be replayed later.