azureblog.co.uk
← cd ~/events
// events/666 · Entra Connect

Event ID 666Failed due to SQL deadlock

Password hash sync failed for a domain because of a SQL deadlock.

LogApplication
SourceDirectory Synchronization
AreaEntra Connect

What to check

Usually transient; if it repeats, check SQL health on the Connect server.

Find it with PowerShell

Run on the machine that logs it.

powershell2 lines
Get-WinEvent -FilterHashtable @{ LogName = 'Application'; Id = 666 } -MaxEvents 50 |
    Format-List TimeCreated, Id, Message

Hunt for it in Sentinel or Log Analytics

This works once a data collection rule sends the Application log to your workspace, where it lands in the Event table.

kql5 lines
Event
| where TimeGenerated > ago(7d)
| where EventLog == "Application" and EventID == 666
| project TimeGenerated, Computer, Source, RenderedDescription
| order by TimeGenerated desc

Related Entra Connect events

Search all 123 event IDs →