Azuredatastudio: New connection to database.usgovcloudapi.net

[Powderhound509]

New connection > someServer.database.usgovcloudapi.net > authentication type = Azure Active Directory - Universal with MFA support > Account = new account > sign in = [email protected] > enter password > account added > connect:

Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool, SqlAuthenticationProviderManager sqlAuthProviderManager) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass40_0.<TryGetConnection>b__1(Task1 _)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass30_0.<b__0>d.MoveNext() in D:\a1\s\src\Microsoft.SqlTools.ManagedBatchParser\ReliableConnection\ReliableSqlConnection.cs:line 314
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 524
ClientConnectionId:25867c62-4ca2-4900-9968-1b3e94cdc954
Error Number:18456,State:1,Class:14

[adsbot[bot]]

Thanks for submitting this issue. Please also check if it is already covered by an existing one, like:

• "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." when trying to connect to an azure SQL instance. (#8815)
• （How can't I support a database with a lower version）怎么不支持低版本的数据库啊 (#7852)
• Only Azure Data Studio for Mac cannot connect to SQL Server in Docker (#9116)
• Azure Active Directory - Universal with MFA support results in connection error (Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.) (AAD) (#4085)
• can't connect to mssql server on secondary dns through linux app (#8636)
  

[kburtram]

@aaomidi any ideas on this one?

[aaomidi]

Have you verified that this server connects via SSMS with AAD?

You also seem to be connecting to a US government cloud DB, is that intentional?

[Powderhound509]

I have confirmed that AAD with MFA does work from SSMS. The behavior has
changed a little bit since I first submitted (see attached). At this
point, I have authenticated my AZGov AAD account via the browser popup and
the Azure Data Studio is just spinning after acknowledging the errors in
the screenshot.

On Thu, May 7, 2020 at 12:00 PM Amir Omidi [e-mail] wrote:

Have you verified that this server connects via SSMS with AAD?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/microsoft/azuredatastudio/issues/10023#issuecomment-625438686,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AGWE5BEX5AEFL54W4B76LITRQMAOHANCNFSM4MJ5GDRQ
.

[aaomidi]

I think this is going to be covered by #10314 but I'll keep this issue open just in case its different

[Powderhound509]

Great, thanks Amir!

On Wed, May 13, 2020 at 1:46 PM Amir Omidi [e-mail] wrote:

I think this is going to be covered by #10314
https://github.com/microsoft/azuredatastudio/issues/10314 but I'll keep
this issue open just in case its different

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/microsoft/azuredatastudio/issues/10023#issuecomment-628236759,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AGWE5BD2VGQQVF2ZTT4AFALRRMBKNANCNFSM4MJ5GDRQ
.

[aaomidi]

Closing this issue for #10314, it seems to me that there is an underlying SqlClient issue, maybe we need to pass some more information.