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

Question

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?

Answer 1

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.

   

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:

   

   

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