CODEWITHSUNDEEP
azureazure-active-directoryservice-principalazure-postgresqlazure-service-principal
S2S2
S2S2

Reputation: 8502

How to Create a Service Principal for Azure database for PostgreSql single server

As per the documentation from Microsoft for Data encryption for Azure Database for PostgreSQL Single server by using the Azure portal , the steps mentioned tell to create a service principal for Azure PostgreSql single server option, while adding an Access Policy in Azure key vault.

I wanted to know how can I create a service principal for Azure Postgresql. I googled across the web but didn't find any descriptive link or documentation to do this.

Can someone please help me achieve this?

Upvotes: 1

Views: 1628

Answers (1)

Ansuman Bal
Ansuman Bal

Reputation: 11451

Please follow the below steps to fix the issue:

  1. You have to configure the data encryption first as shown below which will fail because you don't have a service principal for it but this step is necessary as it will create a new service principal for your PostgreSQL server.

    enter image description here

  2. After the above step fails , go to your Keyvault>>access policies>> add access policy.

    You will be able to see the service principal created for the Postgre and it will have the same name as the PostgreSQL server and add the required permissions for the principal as shown below:

    enter image description here

    enter image description here

  3. Go to the data encryption section for PostgreSQL server again and do the settings like below , it will be successfully saved:

    enter image description here

Upvotes: 1

Related Questions