我无法使用Active集成八月连接到Azure SQL Server。当试图进行身份验证时,我得到下面的错误。
关于如何进一步查明这一问题的任何想法都将是见仁见智的。
干杯
无法连接到XXXXXXX.database.windows.net。
===================================
未能验证用户NT授权\ Active Directory中匿名登录(Authentication=ActiveDirectoryIntegrated)。错误代码0xCAA9002C;状态10无法解析XML blob。原因: XML文档必须具有顶级元素。行: 0,位置:0文本:(null) (.Net SqlClient数据提供程序)
有关帮助,请单击:http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
服务器名称: XXXXXXX.database.windows.net错误号:0严重性: 11状态:0过程: ADALGetAccessToken
节目位置:
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()发布于 2019-07-31 13:30:16
我最近遇到了类似的问题,并注意到我们的Azure实例需要MFA登录。Blob实际上是强制响应的HTML页面。
发布于 2016-09-05 02:35:29
登录到联邦域上的计算机后,我将使用SSMS进行连接。
当尝试连接时,错误将返回给SSMS。
我假设Azure可以通过调用过程: ADALGetAccessToken来识别用户来自联邦域?
谢谢
我
https://stackoverflow.com/questions/39263185
复制相似问题