Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,128 questions
Synapse Error: Acquire Managed Identity token from Azure Active Directory failed. The certificate was expired.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 54%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jamie Boley
5
Reputation points
I have a Synapse Analytics data pipeline that all of sudden stopped working with an error message of: "Acquire Managed Identity token from Azure Active Directory failed. The certificate was expired."
This was setup by a 3rd party vendor and I have limited experience with Azure, but I haven't been able to track down where the certificate expiration exists. The managed identity that is being used is a system defined identity.
However, when I look at managed identities I do not see any records:
I was able to find the Synapse application from the 'Enterprise applications' section, but it says the certificate is managed by Microsoft.
Is there somewhere else I should be looking?
From the Synapse workspace, when test the connection of the linked services, I get the following:
- Azure Data Lake Storage Gen2 (Test connection fails with error)
- Azure Key Vault (Test connection is successful)
- SQL Server (Test connection fails with error)
- Azure Synapse Analytics (Test connection fails with error)
Appreciate any help!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,346 Reputation points2023-10-31T22:38:21.9333333+00:00 Hello @Jamie Boley Welcome to QnA forum.
It sounds like the certificate used by the system-defined managed identity for your Synapse Analytics data pipeline has expired, did you try creating new cert in this scenario?If you are still having issues, you may want to contact the 3rd party vendor who set up the data pipeline for further assistance.
Please do let us know if you need further help in this matter.
-
Jamie Boley 5 Reputation points
2023-11-02T13:47:38.7866667+00:00 I'm not sure where I would go to find the expired certificate and replace it. In my screenshot on my original post; I do not see an entry under the managed identities section.
-
Jamie Boley 5 Reputation points
2023-11-02T13:51:28.9966667+00:00 I do not see the entry in 'Managed Identities' to be able to do anything. Is there somewhere else I should be looking?
-
QuantumCache 20,346 Reputation points
2023-11-15T04:44:58.7166667+00:00 @Jamie Boley If the issue still exits, then please do let us know and we will create an offline support ticket.
-
Jamie Boley 5 Reputation points
2023-11-15T16:55:31.08+00:00 I created a support ticket (2311070040006334). It was suggested to follow these steps, but the code in the documentation is giving me errors so I'm waiting to hear back.
-
QuantumCache 20,346 Reputation points
2023-11-15T17:49:29.3333333+00:00 Thank you for letting us know!
Sign in to comment
Sign in to answer