Sigma rule: OpenCanary - MSSQL Login Attempt Via SQLAuth

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

Rule

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

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

Log source

product: opencanary
category: application

Detection

selection:
    logtype: 9001
condition: selection

False positives (as the rule lists them)

Unlikely

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_sqlauth.yml

Sources and licences

SigmaHQ
"OpenCanary - MSSQL Login Attempt Via SQLAuth" by Security Onion Solutions (SigmaHQ). Rule: https://github.com/SigmaHQ/sigma/blob/ccbb0369507f796db0b0ae6854c8a2be471b9d84/rules/application/opencanary/opencanary_mssql_login_sqlauth.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 SQLAuth",
entity page, dataset version ref-e874f5bf6454, updated 2024-03-08T00:00:00.000Z,
https://ransomware-tracker.com/detections/sigma/3ec9a16d-0b4f-4967-9542-ebf38ceac7dd (accessed 2026-11-03).
Underlying source: SigmaHQ rule 3ec9a16d-0b4f-4967-9542-ebf38ceac7dd, 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.