Azure Active Directory连接字符串 [英] Azure Active Directory Connection String

问题描述

我一直在尝试设置我的IIS网站的连接字符串，以使用以下连接字符串连接到Azure SQL数据库：

I've been trying to set up my IIS website's connection string to connect to an Azure SQL Database with the following connection string:

<add name="ConnectionString" connectionString="Server=tcp:some.database.windows.net,1433;Database=myDB;Authentication=Active Directory Integrated;" />

IIS应用程序池正在使用具有Azure Active Directory权限的服务帐户，并作为用户添加在Azure SQL数据库上。

The IIS application pool is using a service account which has Azure Active Directory privileges and is added as an user on the Azure SQL Database.

这在我的本地开发机器上工作正常（可能是因为它使用我的凭据而不是服务帐户）但是当我放置网站时我得到的IIS：

This works fine on my local development machine (probably because it is using my credentials and not a service account) but when I place the site on IIS I get:

System.ArgumentException: Keyword not supported: 'authentication'.

有没有人知道通过Azure AD登录的正确语法？

Does anyone know the correct syntax for logging in via Azure AD?

推荐答案

您是否阅读了本故障排除指南， https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/# 5-configure-your-client-computers ？

Have you been through this troubleshooting guide, https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/#5-configure-your-client-computers?

特别是，你安装了.NET Framework 4.6或更高版本吗？

In particular, do you have .NET Framework 4.6 or later installed?

这篇关于Azure Active Directory连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！