An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hi **Jordan Berry
This behavior is typically caused by the Self-Hosted Integration Runtime repeatedly authenticating to Azure Active Directory with stale or invalid credentials. When this happens continuously, Azure AD lockout policies are triggered, even though pipelines may still appear to run.
In most cases, the root cause is cached or outdated credentials on the SHIR host. This often occurs after a service account password is rotated in Azure AD but not updated on the SHIR machine or in linked services. The Windows service running SHIR can keep retrying authentication in the background, resulting in repeated failed sign-ins and eventual account lockout.
Network or proxy instability is another common contributor. If the SHIR node cannot reliably reach Azure AD endpoints due to firewall rules, proxy misconfiguration, DNS issues, or intermittent TLS failures, the runtime retries authentication and each retry counts as a failed sign-in.
Azure AD Conditional Access or lockout policies can also play a role. Service accounts used by SHIR may unintentionally be subject to MFA or strict lockout rules, causing repeated authentication failures.
To confirm the cause, review Azure AD sign-in logs for the affected account. These typically show repeated failures from the SHIR machine’s IP or hostname. SHIR logs on the node usually align with the same timestamps.
A practical fix is to reset the service account password, update all linked services and SHIR configurations, and restart the Integration Runtime service. Using a service principal with certificate-based authentication greatly reduces lockout risk. Longer term, Microsoft Fabric or the On-Premises Data Gateway can help by reducing reliance on user-based Azure AD authentication in hybrid scenarios.
In short, this is almost always caused by repeated Azure AD authentication failures from the SHIR host rather than a Synapse or pipeline issue.