Managed identity postgres flexible server

Question

Hello to all.
I want to create a Postgres flexible server database without thinking about credentials. I heard that Azure
has a solution for such cases: Managed identity. Can someone describe how this happens?
Thanks in advance.

Regards,

Nasimjon.

Answer 1

Hi Nasimjon Tohirov •,

Welcome to Microsoft Q&A forum.

As I understand, you want to connect to Azure Database for PostgreSQL Flexible server using Managed Identity.

• If you're not familiar with the managed identities for Azure resources feature, see this overview. If you don't have an Azure account, sign up for a free account before you continue.
• To do the required resource creation and role management, your account needs "Owner" permissions at the appropriate scope (your subscription or resource group). If you need assistance with a role assignment, see Assign Azure roles to manage access to your Azure subscription resources.
• You need an Azure VM (for example, running Ubuntu Linux) that you'd like to use to access your database using Managed Identity
• You need an Azure Database for PostgreSQL database server that has Azure AD authentication configured
• To follow the C# example, first, complete the guide on how to Connect with C#

Refer for complete details:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-with-managed-identity

and

https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/overview

Please try and let us know if stuck at any step.

Thanks