"Server=tcp:<MyServer>.database.windows.net,1433;Initial Catalog=<MyDB>;;Authentication=Active Directory Device Code Flow;"

CMS.DataEngine.ApplicationInitException: 'Keyword not supported: 'authentication'.'

protected override IDbConnection CreateNativeConnection()
{
    var conn = new SqlConnection(ConnectionString);
    var credential = new Azure.Identity.DefaultAzureCredential();
    var token = credential.GetTokenAsync(new Azure.Core.TokenRequestContext(new[] { "https://database.windows.net//.default" }),default);
    return conn;
}
```"
<details>
<summary>英文:</summary>
Looks like there is a way to customize creating the database context in Kentico.
https://docs.xperience.io/custom-development/customizing-providers/custom-data-provider-example
I followed the steps mentioned in the above article and then modified the `DataConnection` class, `CreateNativeConnection` method as below
    protected override IDbConnection CreateNativeConnection()
    {
    	var conn = new SqlConnection(ConnectionString);
    	var credential = new Azure.Identity.DefaultAzureCredential();
    	var token = credential.GetTokenAsync(new Azure.Core.TokenRequestContext(new[] { &quot;https://database.windows.net//.default&quot; }),default);
    	return conn;
    }
</details>
# 答案2
**得分**: 0
我会尝试在Google或MSDN页面上搜索，因为这与Azure SQL更相关，而不是Kentico。例如，我找到了这个链接：[教程：使用Windows VM系统分配的托管标识访问Azure SQL][1] 或 [Azure SQL的Azure AD托管标识][2]，看起来你需要使用Azure AD。本地标识可能不受支持。我建议向Azure SQL支持部门咨询。
[1]: https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/tutorial-windows-vm-access-sql
[2]: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
<details>
<summary>英文:</summary>
I would try searching on Google or MSDN pages as this is more related to Azure SQL and not Kentico. E.g. I found this: [Tutorial: Use a Windows VM system-assigned managed identity to access Azure SQL][1]
or [Managed identities in Azure AD for Azure SQL][2] and as it looks like, you need to use Azure AD. Local identities are probably not supported. I would maybe ask Azure SQL support. 
  [1]: https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/tutorial-windows-vm-access-sql
  [2]: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
</details>