Answer recommended by moderator
So I was able to get a deployment successfully made when switching the region to eastus2. There was ZERO mention of anything region-specific in the error. What you see above is the error that is presented to the user and it is astounding to me that this is considered acceptable by every person working at Azure.
-
Mike-E-angelo 631 Reputation points
Ironically I was using
eastusbecauseeastus2was throwing errors regarding databases at one point. This whole system is truly Jenga, especially when very little information is presented to the user to help them solve the problem they are experiencing. -
Anonymous
The error means the connection didn’t have a valid database context or the Entra identity isn’t fully registered inside that database. You don’t need to add pgaadauth as an extension manually—it’s built into the service. The right approach is to enable Entra authentication at the server and then create the identity as a principal in the target database.
Make sure you’re connecting with the correct FQDN (not IP), using SSL, and explicitly specifying the database name.
After that, confirm the identity exists in that database and grant the roles you need. Without that, even if the token looks fine, the database won’t recognize you.
If you’re on Flexible Server, this is the standard flow. If it’s Cosmos DB for PostgreSQL, the steps differ slightly.
-
Mike-E-angelo 631 Reputation points
Hi @Anonymous thank you for your reply.
The error means the connection didn’t have a valid database context or the Entra identity isn’t fully registered inside that database. You don’t need to add pgaadauth as an extension manually—it’s built into the service. The right approach is to enable Entra authentication at the server and then create the identity as a principal in the target database.
How can you be so sure about this? Exactly zero of this is relayed in the error message presented to me. Additionally, as I was able to deploy to eastus2 without issue, this also seems to imply this was a different issue altogether than you are suggesting.
-
Anonymous
Hi Mike,
Thank you for the detailed feedback and for your patience here – I completely understand how frustrating it is to wait ~70 minutes only to see a generic “deployment failed” error with no actionable details.
Based on the behavior you described and the fact that the same Redis Enterprise deployment succeeds in eastus2 but consistently fails in eastus, this strongly suggests a region-specific platform/capacity issue in
eastusrather than a problem with your ARM/Bicep template or parameters.the deployment should fail quickly with a clear reason such as “SKU unavailable or capacity exhausted in this region” instead of a generic
ResourceDeploymentFailureafter a long timeout. I’ve flagged this feedback to the team so they can review both the error message and the timeout behavior for such cases. -
Anonymous
I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications
Sign in to comment
