SQL Prompt Suggestions aren't loading

haydn

I works when SSMS v18.1 is freshly opened and I connect to an Azure DB using SQL Prompt 9.5.18.11513
but if i change the connection to a different Azure DB,the prompt suggestions file to be retrieved.
I've seen comments on this issue before. from the logs:

25 Sep 2019 03:32:11,368 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection

25 Sep 2019 03:32:11,369 [14] DEBUG RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Checking is contained or restricted

25 Sep 2019 03:32:12,420 [14] DEBUG RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Contained or restricted - Azure

25 Sep 2019 03:32:14,429 [14] DEBUG RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Loading server capabilities

25 Sep 2019 03:32:14,489 [14] INFO  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities SqlAzureV12

25 Sep 2019 03:32:14,959 [14] INFO  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Server does not support linking to other servers

25 Sep 2019 03:32:14,966 [14] DEBUG RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Loading server logins

25 Sep 2019 03:32:14,970 [14] INFO  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Login suggestions are not supported for SqlAzureV12 servers

25 Sep 2019 03:32:14,976 [7] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [azure-db-01.database.windows.net].[master] progress: Connecting...

25 Sep 2019 03:32:14,977 [1] DEBUG RedGate.SQLPrompt.CommonUI.Forms.TaskExecuter.ViewModels.LoadingProgressPopupViewModel - Closing messages for azure-db-01.database.windows.net

25 Sep 2019 03:32:16,152 [7] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [azure-db-01.database.windows.net].[master] 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, 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:039b0335-3332-46b9-842d-27b3323f2651

Error Number:18456,State:1,Class:14

25 Sep 2019 03:32:16,193 [1] DEBUG RedGate.SQLPrompt.CommonUI.Forms.TaskExecuter.ViewModels.LoadingProgressPopupViewModel - Closing messages for Database: 'master'

25 Sep 2019 03:32:16,205 [1] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [49335] Started task 'Matching object names'.

25 Sep 2019 03:32:16,613 [86] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork<ParserWorkInput, List<Range>> - [49335] Run 'Matching object names' completion handler!

25 Sep 2019 03:32:16,615 [86] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [49335] Successfully finishing current task 'Matching object names'.

25 Sep 2019 03:32:21,515 [52] DEBUG RedGate.SQLPrompt.CommonVS.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database PROD_RACVic

25 Sep 2019 03:32:21,672 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection

25 Sep 2019 03:32:21,674 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 943119468

thanks

Tianjiao_Li

Hi @haydn

Thanks for reporting this issue!

At the moment, Azure SQL database is not officially supported. It'll be really helpful if you can add your vote to the user voice suggestion that I posted on https://forum.red-gate.com/discussion/85651/ssms-18-2-with-sql-prompt-9-5-does-not-seem-to-work-connecting-to-azure-sql-db

Thanks.