Secure Azure Cosmos credentials using Azure Key Vault
APPLIES TO: SQL API Cassandra API Gremlin API Table API Azure Cosmos DB API for MongoDB
The recommended solution to access Azure Cosmos DB is to use a system-assigned managed identity. If your service cannot take advantage of managed identities then use the cert based solution. If both the managed identity solution and cert based solution do not meet your needs, please use the key vault solution below.
When using Azure Cosmos DB, you can access the database, collections, documents by using the endpoint and the key within the app's configuration file. However, it's not safe to put keys and URL directly in the application code because they're available in clear text format to all the users. You want to make sure that the endpoint and keys are available but through a secured mechanism. This scenario is where Azure Key Vault can help you to securely store and manage application secrets.
The following steps are required to store and read Azure Cosmos DB access keys from Key Vault:
- Create a Key Vault
- Add Azure Cosmos DB access keys to the Key Vault
- Create an Azure web application
- Register the application & grant permissions to read the Key Vault
Create a Key Vault
- Sign in to Azure portal.
- Select Create a resource > Security > Key Vault.
- On the Create key vault section provide the following information:
- Name: Provide a unique name for your Key Vault.
- Subscription: Choose the subscription that you'll use.
- Within Resource Group, choose Create new and enter a resource group name.
- In the Location pull-down menu, choose a location.
- Leave other options to their defaults.
- After providing the information above, select Create.
Add Azure Cosmos DB access keys to the Key Vault.
Navigate to the Key Vault you created in the previous step, open the Secrets tab.
- Select Manual for Upload options.
- Provide a Name for your secret
- Provide the connection string of your Cosmos DB account into the Value field. And then select Create.
After the secret is created, open it and copy the **Secret Identifier that is in the following format. You'll use this identifier in the next section.
Create an Azure web application
Create an Azure web application or you can download the app from the GitHub repository. It's a simple MVC application.
Unzip the downloaded application and open the HomeController.cs file. Update the secret ID in the following line:
var secret = await keyVaultClient.GetSecretAsync("<Your Key Vault’s secret identifier>")
Save the file, Build the solution.
Next deploy the application to Azure. Open the context menu for the project and choose publish. Create a new app service profile (you can name the app WebAppKeyVault1) and select Publish.
Once the application is deployed from the Azure portal, navigate to web app that you deployed, and turn on the Managed service identity of this application.
If you run the application now, you'll see the following error, as you have not given any permission to this application in Key Vault.
Register the application & grant permissions to read the Key Vault
In this section, you register the application with Azure Active Directory and give permissions for the application to read the Key Vault.
Navigate to the Azure portal, open the Key Vault you created in the previous section.
Open Access policies, select +Add New find the web app you deployed, select permissions and select OK.
Now, if you run the application, you can read the secret from Key Vault.
Similarly, you can add a user to access the key Vault. You need to add yourself to the Key Vault by selecting Access Policies and then grant all the permissions you need to run the application from Visual studio. When this application is running from your desktop, it takes your identity.
Submit and view feedback for