SQL Prompt 9.0.2.3223 - Azure SQL - Failed To Load

higgimhiggim Posts: 6 New member
We use AD logins with MFA for our Azure SQL servers. After a short period of time when refreshing suggestions, we get a failed to load error. Disconnecting and reconnecting from the server, closing the query window and re-opening seems to resolve (not really a workable solution).

This problem shows for all versions of SSMS (Currently using v17.4)

Logs are below

19 Dec 2017 09:19:34,011 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document opened
19 Dec 2017 09:19:34,189 [207] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [myazuresqlserver.database.windows.net].[mysqlazuredb] progress: Waiting for master database
19 Dec 2017 09:19:34,193 [207] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [myazuresqlserver.database.windows.net].[mysqlazuredb] progress: Connecting...
19 Dec 2017 09:19:34,631 [207] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [myazuresqlserver.database.windows.net].[mysqlazuredb] Cache finished with warnings:
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
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 RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()
ClientConnectionId:b0036d4d-3c31-4d17-9d5f-fb74670fc616
Error Number:18456,State:1,Class:14

Please advise

Answers

  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hi @higgim ,

    So sorry to hear you're running into an issue!

    There is a known bug (SP-6659) that's still being investigated, where SQL Prompt may lock out AD accounts when trying to connect to Azure, but I don't think that's the issue here if just restarting SSMS resolves the login failure.

    Just to confirm- it happens only after an eventual SQL Prompt>Refresh suggestions?

    Do you have Tab History enabled? I'm wondering if one of the tabs has an invalid connection. If you close all of your tabs, does the error still come up?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • higgimhiggim Posts: 6 New member
    Hi. Thanks for the reply. This only happens when refreshing suggestions (at least that’s when we notice it). Disconnecting and reconnecting and closing query window does resolve for a short period. (Guessing it picks up the ad login again)

    Tab history is not enabled. Closing all tabs, then starting a new tab does not resolve. Only closing all tabs, disconnecting and reconnecting resolves (as per above)

    Cheers.

    M
  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Thanks @higgim!

    Can you kindly update to the latest version (SQL Prompt>Help>Check for updates) to make sure the problem is still occurring there?

    If so, would you be able to post the entire log file for us to take a look at?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • higgimhiggim Posts: 6 New member
    Will do in the morning. I already have latest version.
  • higgimhiggim Posts: 6 New member
    As requested:

    22 Dec 2017 08:55:55,771 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document opened
    22 Dec 2017 08:55:55,925 [1] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Created new ServerCandidate for server: <azuresqlserver>.database.windows.net
    22 Dec 2017 08:55:56,303 [221] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12
    22 Dec 2017 08:55:56,403 [221] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers
    22 Dec 2017 08:55:56,403 [221] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggetions are not supported for SqlAzureV12 servers
    22 Dec 2017 08:55:56,424 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Connecting...
    22 Dec 2017 08:55:56,424 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 08:55:56,525 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[master] as SqlAzureV12
    22 Dec 2017 08:55:57,279 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing schemas...
    22 Dec 2017 08:55:57,281 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing objects...
    22 Dec 2017 08:55:57,990 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing master objects...
    22 Dec 2017 08:55:58,006 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing triggers...
    22 Dec 2017 08:55:58,006 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing datatypes...
    22 Dec 2017 08:55:58,059 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing datatypes...
    22 Dec 2017 08:55:58,059 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing columns...
    22 Dec 2017 08:55:58,091 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing parameters...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing indexes...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing foreign keys...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing primary keys...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing roles...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing users...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing default schema...
    22 Dec 2017 08:55:58,106 [267] INFO RedGate.SqlPrompt.Cache.Population.Steps.DefaultSchemaPopulationStep - Unable to retrieve default schema
    System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
    at RedGate.SqlPrompt.Cache.Population.Steps.DefaultSchemaPopulationStep.Populate(IDataReader reader)
    22 Dec 2017 08:55:58,124 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing synonyms...
    22 Dec 2017 08:55:58,126 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Processing descriptions...
    22 Dec 2017 08:55:58,128 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Indexing all database columns
    22 Dec 2017 08:55:58,128 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] progress: Fetching script information
    22 Dec 2017 08:55:58,128 [267] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[master] Cache finished with no warnings
    22 Dec 2017 08:55:58,128 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 08:55:58,244 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[<azuredb>] as SqlAzureV12
    22 Dec 2017 08:55:59,996 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing schemas...
    22 Dec 2017 08:55:59,996 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing objects...
    22 Dec 2017 08:55:59,996 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing master objects...
    22 Dec 2017 08:56:00,011 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing triggers...
    22 Dec 2017 08:56:00,011 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:56:00,011 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:56:00,011 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing columns...
    22 Dec 2017 08:56:00,080 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing parameters...
    22 Dec 2017 08:56:00,080 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing indexes...
    22 Dec 2017 08:56:00,164 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing foreign keys...
    22 Dec 2017 08:56:00,164 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing primary keys...
    22 Dec 2017 08:56:00,164 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing roles...
    22 Dec 2017 08:56:00,164 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing users...
    22 Dec 2017 08:56:00,180 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing default schema...
    22 Dec 2017 08:56:00,180 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing synonyms...
    22 Dec 2017 08:56:00,180 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing descriptions...
    22 Dec 2017 08:56:00,180 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Indexing all database columns
    22 Dec 2017 08:56:00,180 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Fetching script information
    22 Dec 2017 08:56:00,180 [221] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with no warnings
    22 Dec 2017 08:58:46,554 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 08:58:46,554 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 08:58:46,668 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[<azuredb>] as SqlAzureV12
    22 Dec 2017 08:58:46,668 [243] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing schemas...
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing objects...
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing master objects...
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing triggers...
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:58:46,699 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing columns...
    22 Dec 2017 08:58:46,721 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing parameters...
    22 Dec 2017 08:58:46,721 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing indexes...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing foreign keys...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing primary keys...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing roles...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing users...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing default schema...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing synonyms...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing descriptions...
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Indexing all database columns
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Fetching script information
    22 Dec 2017 08:58:46,737 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with no warnings
    22 Dec 2017 08:58:46,768 [243] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers
    22 Dec 2017 08:58:46,768 [243] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggetions are not supported for SqlAzureV12 servers
    22 Dec 2017 08:58:50,746 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 08:58:50,746 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 08:58:50,846 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[<azuredb>] as SqlAzureV12
    22 Dec 2017 08:58:50,846 [188] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing schemas...
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing objects...
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing master objects...
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing triggers...
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:58:50,878 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing columns...
    22 Dec 2017 08:58:50,893 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing parameters...
    22 Dec 2017 08:58:50,893 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing indexes...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing foreign keys...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing primary keys...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing roles...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing users...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing default schema...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing synonyms...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing descriptions...
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Indexing all database columns
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Fetching script information
    22 Dec 2017 08:58:50,909 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with no warnings
    22 Dec 2017 08:58:50,947 [188] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers
    22 Dec 2017 08:58:50,947 [188] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggetions are not supported for SqlAzureV12 servers
    22 Dec 2017 08:59:01,273 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Query executed
    22 Dec 2017 08:59:06,587 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 08:59:06,587 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 08:59:06,703 [50] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12
    22 Dec 2017 08:59:06,703 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[<azuredb>] as SqlAzureV12
    22 Dec 2017 08:59:06,718 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing schemas...
    22 Dec 2017 08:59:06,718 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing objects...
    22 Dec 2017 08:59:06,734 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing master objects...
    22 Dec 2017 08:59:06,734 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing triggers...
    22 Dec 2017 08:59:06,734 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:59:06,734 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 08:59:06,734 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing columns...
    22 Dec 2017 08:59:06,750 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing parameters...
    22 Dec 2017 08:59:06,750 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing indexes...
    22 Dec 2017 08:59:06,750 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing foreign keys...
    22 Dec 2017 08:59:06,766 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing primary keys...
    22 Dec 2017 08:59:06,767 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing roles...
    22 Dec 2017 08:59:06,768 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing users...
    22 Dec 2017 08:59:06,769 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing default schema...
    22 Dec 2017 08:59:06,770 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing synonyms...
    22 Dec 2017 08:59:06,771 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing descriptions...
    22 Dec 2017 08:59:06,772 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Indexing all database columns
    22 Dec 2017 08:59:06,772 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Fetching script information
    22 Dec 2017 08:59:06,772 [282] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with no warnings
    22 Dec 2017 08:59:06,803 [50] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers
    22 Dec 2017 08:59:06,803 [50] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggetions are not supported for SqlAzureV12 servers
    22 Dec 2017 09:11:38,135 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 09:11:38,135 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 09:11:38,282 [292] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12
    22 Dec 2017 09:11:38,298 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[<azuredb>] as SqlAzureV12
    22 Dec 2017 09:11:38,314 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing schemas...
    22 Dec 2017 09:11:38,330 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing objects...
    22 Dec 2017 09:11:38,331 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing master objects...
    22 Dec 2017 09:11:38,333 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing triggers...
    22 Dec 2017 09:11:38,334 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 09:11:38,335 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 09:11:38,336 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing columns...
    22 Dec 2017 09:11:38,351 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing parameters...
    22 Dec 2017 09:11:38,351 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing indexes...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing foreign keys...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing primary keys...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing roles...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing users...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing default schema...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing synonyms...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing descriptions...
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Indexing all database columns
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Fetching script information
    22 Dec 2017 09:11:38,367 [256] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with no warnings
    22 Dec 2017 09:11:38,398 [292] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers
    22 Dec 2017 09:11:38,398 [292] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggetions are not supported for SqlAzureV12 servers
    22 Dec 2017 09:27:55,927 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 09:27:55,946 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 09:27:56,081 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [<azuresqlserver>.database.windows.net].[<azuredb>] as SqlAzureV12
    22 Dec 2017 09:27:56,081 [232] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing schemas...
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing objects...
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing master objects...
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing triggers...
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing datatypes...
    22 Dec 2017 09:27:56,096 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing columns...
    22 Dec 2017 09:27:56,112 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing parameters...
    22 Dec 2017 09:27:56,112 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing indexes...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing foreign keys...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing primary keys...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing roles...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing users...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing default schema...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing synonyms...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Processing descriptions...
    22 Dec 2017 09:27:56,128 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Indexing all database columns
    22 Dec 2017 09:27:56,144 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Fetching script information
    22 Dec 2017 09:27:56,145 [84] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with no warnings
    22 Dec 2017 09:27:56,187 [232] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers
    22 Dec 2017 09:27:56,188 [232] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggetions are not supported for SqlAzureV12 servers
    22 Dec 2017 10:09:51,933 [83] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Waiting for master database
    22 Dec 2017 10:09:51,933 [83] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] progress: Connecting...
    22 Dec 2017 10:09:52,149 [83] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [<azuresqlserver>.database.windows.net].[<azuredb>] Cache finished with warnings:
    System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
    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 RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()
    ClientConnectionId:30992892-83b2-41dd-9069-39f661d5cdde
    Error Number:18456,State:1,Class:14
    22 Dec 2017 10:09:52,149 [19] WARN RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Failed to load server <azuresqlserver>.database.windows.net
    System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
    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 RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()
    ClientConnectionId:07d0920a-b0aa-4904-b33b-8fb98225d5d4
    Error Number:18456,State:1,Class:14
  • higgimhiggim Posts: 6 New member
    From the server audit logs

    EVENT TIME (UTC) 12/22/2017 10:09:52 AM
    EVENT TYPE DATABASE AUTHENTICATION FAILED
    SERVER NAME <azureservername>
    DATABASE NAME <azuredatabase>
    APPLICATION NAME Red Gate Software Ltd SQL Prompt 9.0.2.3223
    CLIENT IP <ipaddress>
    STATUS Failed
    ADDITIONAL INFORMATION <login_information><error_code>18456</error_code><error_state>132</error_state></login_information>
  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Thanks @higgim!

    Do you have any Additional Connection Parameters set for your connection? Or do you have any extra connection properties set?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • higgimhiggim Posts: 6 New member
    No to both questions.
  • Hi @higgim

    We have this issue logged as SP-6242 in our internal bug tracking system. I'll speak to the development team and update you as soon as possible.

    Our apologies for the inconvenience caused.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Hi @higgim

    Thanks for your patience with this issue.

    Unfortunately the development team hasn't been able to prioritise this work. Given the size of the backlog of higher-priority items, it doesn't look like it's something we will fix in the foreseeable future.

    However we still have it logged as SP-6242 in our internal bug tracking system and we'll reassess it again in the future. Please keep an eye on the release note!

    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • sanasana Posts: 1 New member
    Has this issue been fixed yet? 
  • mschumachermschumacher Posts: 2 New member
    still seems to be a problem on 9.5.13.11024 - SSMS 18.1 

    Any work arounds known to work to get suggestions to work ?

    20 Aug 2019 16:25:10,881 [9] WARN  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Failed to load server xxxxxxxx.database.windows.net
    System.Data.SqlClient.SqlException (0x80131904): Cannot open server "xxxxxx.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.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 RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.IsContainedOrRestrictedDatabase(ConnectionProperties cp)
       at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadDatabaseContainment()
       at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()
    ClientConnectionId:09bcfc64-c46a-41f7-af23-c393fd48f2bc
    Error Number:40532,State:1,Class:20
  • haydnhaydn Posts: 2 New member
    SQL Server Management Studio 15.0.18131.0
    SQL Prompt 9.5.16.11294 


    System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
       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.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 RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()
    ClientConnectionId:95ec1792-5461-43f7-903f-c955c4ce19e2
    Error Number:18456,State:1,Class:14

    thanks
  • JoeLeBaronJoeLeBaron Posts: 13 Bronze 1
    2.5 years later, this is still a problem.  The issue is the MFA.   The token expires and a new one has to be acquired.  I believe the default is 1 hour.  SSMS handles this automatically, but SQL Prompt does not.  Restarting SSMS causes SQL Prompt to restart and acquire the new token.  

    Not a workable solution.
Sign In or Register to comment.