OpenCanary MSSQL SQLAuth Login Attempt Detected (logtype 9001)
Flags MSSQL SQLAuth login attempts recorded by OpenCanary for credential-access style activity.
FreeReviewedSigma · High · v5
- Product
- opencanary
- Category
- application
- Author
- Security Onion Solutions (SigmaHQ), DRL 1.1
- Published
- 2024-03-08
- Updated
- 2026-07-31
ATT&CK techniques
Cred Access → CollectionRecon
Resource Dev
Initial Access
Execution
Persistence
Priv Esc
Defense Evasion
Cred Access
Discovery
Lateral Movement
Collection
C2
Exfiltration
Impact
What it detects
This rule flags OpenCanary nodes that record an MSSQL service login attempt using SQLAuth. Credential access and login attempts are key attacker behaviors because they indicate attempts to authenticate against exposed services. Detection relies on OpenCanary application telemetry with logtype 9001 indicating the SQLAuth login attempt event.
Reporting behind it
- opencanary.readthedocs.iohttps://opencanary.readthedocs.io/en/latest/starting/configuration.html#services-configuration
- github.comhttps://github.com/thinkst/opencanary/blob/a0896adfcaf0328cfd5829fe10d2878c7445138e/opencanary/logger.py#L52
- github.comhttps://github.com/SigmaHQ/sigma/blob/master/rules/application/opencanary/opencanary_mssql_login_sqlauth.yml
Changelog
v5- v5Candidate ingested via manual entry.2026-07-31
- v4Candidate ingested via manual entry.2026-07-31
- v3Candidate ingested via manual entry.2026-07-31
- v2Candidate ingested via manual entry.2026-07-31
- v1No changelog recorded for this version.2026-07-30
Detection content is published as a reviewed draft. Tune thresholds and exclusions against your own telemetry before enabling this rule for alerting.
opencanary-mssql-sqlauth-login-attempt-detected-3ec9a16d
title: OpenCanary MSSQL SQLAuth Login Attempt Detected (logtype 9001)
id: a8aeb3f2-32e8-47ec-af41-6a0576e19e93
status: test
description: This rule flags OpenCanary nodes that record an MSSQL service login attempt using SQLAuth. Credential access and login attempts are key attacker behaviors because they indicate attempts to authenticate against exposed services. Detection relies on OpenCanary application telemetry with logtype 9001 indicating the SQLAuth login attempt event.
references:
- https://opencanary.readthedocs.io/en/latest/starting/configuration.html#services-configuration
- https://github.com/thinkst/opencanary/blob/a0896adfcaf0328cfd5829fe10d2878c7445138e/opencanary/logger.py#L52
- https://github.com/SigmaHQ/sigma/blob/master/rules/application/opencanary/opencanary_mssql_login_sqlauth.yml
author: Security Onion Solutions, Huntrule Team
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
license: DRL-1.1
related:
- id: 3ec9a16d-0b4f-4967-9542-ebf38ceac7dd
type: derived