---
title: "SQL Server - Azure SQL"
visibility: "public"
---

# Connecting an Azure SQL database

- Click “SQL database”
- Enter JDBC connection string (found at “SQL database” → “Settings” → “Connection strings” in Azure portal)
- Click save (you may need to refresh the page)

![](/media/aab9ffd11dba1fcca12d24a0f21179a6aa648f800ac8e60c4500a43947a6642c/5329bbe1-c920-4ff0-8be5-0a8181d477c6.png)

## Managed Identity (App Service):

- Assign App Service a system managed identity
- Give managed identity access to database
- In connection string, add `authentication=ActiveDirectoryManagedIdentity`

## Token based:

- In the SQL database, make sure the Enterprise Application used to authenticate Convier users is added
  - `CREATE USER [<name of enterprise app registration>] FROM EXTERNAL PROVIDER`
- In Convier, click “Authentication”
- Select “App token”
  - Enter scope “https://database.windows.net/.default”

## Save

![](/media/4871c2449841c48995696cefd9fefbadea04624e26acab0a1ee150bf60bb997c/1bd89f86-3247-48e3-9bd7-583c297bbc80.png)
