SQL Prompt 7.5.1 and SSMS 17.2

beetle

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?

Michael Clark

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

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!

Michael Clark

Brilliant, we're very happy to hear you are back up and running.

Best wishes,

Michael