What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt Suggestions aren't loading

haydnhaydn Posts: 2 New member
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

Answers

Sign In or Register to comment.