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 and refreshed, and the option in Suggestions -> Connections is set to "Load suggestions for all databases". So far, it appears to be just the one server and I don't see anything that would prevent suggestions on this server. Any ideas?
Comments
3 comments
-
Hi @beetle,
Thanks for getting in touch. Sorry to hear that you are having trouble seeing suggestions for that server. Please could you see if there are any errors in the log file and paste them here if so.
You can access the log file from the main menu of SQL Prompt via:
SQL Prompt -> Help -> Show Log
Best wishes,
Michael -
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! -
Brilliant, we're very happy to hear you are back up and running.
Best wishes,
Michael
Add comment
Please sign in to leave a comment.