Connecting to Azure services
SQL Tran can user Microsoft Entra Managed Identities and Service Principals to connect to:
Microsoft SQL Server integrated with Microsoft Entra
Azure SQL Managed Instance
Azure SQL Database
Synapse Dedicated SQL pool
Microsoft Fabric SQL endpoints
Microsoft Entra Managed Identity is the recommended authentication method for databases hosted in the same Azure tenant as the SQL Tran deployment.
Microsoft Entra Service Principal can be used as an authentication method for databases hosted in the same Azure tenant as the SQL Tran deployment and/or different Azure tenants.
The downside of using the Microsoft Entra Service Principal approach is the secret which needs to be manually recreated and pasted into SQL Tran upon expiration of its validity which can be set to up to 2 years.
Last updated