How can we help you today? How can we help you today?
steve
Yeah, we're using Azure Active Directory Auth with MFA for our SQL instances and AZ-DWH (now Synapse) instances. Neither SQLSearch or SQLPrompt seems to like this as neither provides anything useful.  Looks like it doesn't support this form of Auth The error that gets logged is Cannot open server "mydomain.com" requested by the login.  The login failed. we are logging in using our AAD mail addresss as our login :: fred.blogs@ourdomain.com We get the same error in Prompt: 24 Apr 2020 08:42:00,126 [1] INFO  RedGate.Cache.Candidates.ServerCandidate - Created new ServerCandidate for server: ourdatabase.database.windows.net 24 Apr 2020 08:42:00,398 [110] WARN  RedGate.Cache.Candidates.ServerCandidate - Failed to load server ourdatabase.database.windows.net System.Data.SqlClient.SqlException (0x80131904): Cannot open server "mydomain.com" requested by the login.  The login failed. The error logs for Search look like this 24 Apr 2020 09:41:55.578 [112] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list System.Data.SqlClient.SqlException (0x80131904): Cannot open server "mydomain.com" requested by the login.  The login failed.    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, SqlAuthenticationProviderManager sqlAuthProviderManager)    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)    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 RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString) ClientConnectionId:4fc06d6f-0ea4-4721-957a-552059d38530 Error Number:40532,State:1,Class:20 24 Apr 2020 09:41:55.846 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy / comments
Yeah, we're using Azure Active Directory Auth with MFA for our SQL instances and AZ-DWH (now Synapse) instances. Neither SQLSearch or SQLPrompt seems to like this as neither provides anything usefu...
0 votes