ODBC AD集成身份验证-Azure AD域服务 [英] ODBC AD Integrated Authentication - Azure AD Domain Services

问题描述

我正在尝试将Azure VM上的ODBC数据源配置为托管SQL Azure数据库，并且无法使集成身份验证起作用.认证失败，并显示无法认证用户< username>".在Active Directory中(身份验证 选项为"ActiveDirectoryIntegrated"

I'm trying to configure an ODBC data source on an Azure VM to a managed SQL Azure db and can't get the Integrated Authentication to work.   Authentication fails with a "Failed to authenticate user <username> in Active Directory (Authentication Option is 'ActiveDirectoryIntegrated'

我正在使用  VM上仅基于云的AD，托管的SQL Azure DB和ODBC驱动程序版本17.2.我已经在Azure AD域服务中创建了用户，然后使用TSQL在数据库中创建了登录名.如果选择交互式"，则ODBC连接有效 在ODBC配置中进行身份验证.这会溅起一个Web UI以通过Azure AD进行身份验证.  我可以放入pw和ODBC对接工程.但是我想使用AD集成的auth选项，这样不会提示用户.

I'm using  Cloud Based only AD, a managed SQL Azure DB and ODBC driver version 17.2 on th VM.  I've created the user in the Azure AD Domain Services then created the login in the db using TSQL. The ODBC connection works if I select Interactive Auth in the ODBC config. That splashes a Web UI to auth with Azure AD.   I can put in the pw and ODBC conncection works.  But I want to use the AD integrated auth option so the user isn't prompted like this.

这可能吗?

推荐答案

是否可能不支持您正在使用的用户帐户? (即不是域用户)https://blogs.msdn.microsoft.com/sqlsecurity/2015/09/28/examples-of-some-connection-errors-for-azure-active-directory-authentication/

Is it possible that the user account you are using is not supported? (i.e. is not a domain user) https://blogs.msdn.microsoft.com/sqlsecurity/2015/09/28/examples-of-some-connection-errors-for-azure-active-directory-authentication/

这篇关于ODBC AD集成身份验证-Azure AD域服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！