Activity overview
Latest activity by beetle
OK, I found the issue in the log, and the way to work around it.
07 Sep 2017 18:14:19,651 [47] WARN RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Failed to load server ServerNameRemoved
System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) ---> System.ComponentModel.Win32Exception (0x80004005): The certificate chain was issued by an authority that is not trusted
That was in the log. I checked the Trust server certificate box in Connection Properties and reconnected. Now suggestions are loading. Thanks! / comments
OK, I found the issue in the log, and the way to work around it.
07 Sep 2017 18:14:19,651 [47] WARN RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Failed to load server ServerNameRemoved
Sy...
SQL Prompt 7.5.1 and SSMS 17.2
I just installed SSMS 17.2 and I've noticed that while SQL Prompt works fine for some servers and databases, I have one server where SQL Prompt does not load suggestions. Suggestions are enabled an...