Update has caused Prompt to stop working
lboudreaux
Posts: 2 Bronze 1
in SQL Prompt
I updated my SQL Prompt to 10.13.12.1701 this morning and following the update SQL Prompt no longer works. Clicking refresh doesn't do anything nor do I get suggestions for my queries except Snippets.
SQL Prompt 10.13.12.1701
SQL Prompt 10.13.12.1701
SQL Server Management Studio 15.0.18424.0
Tagged:
Answers
Edit - Yes the suggestion above for change connection option to trust server certificate seems to have it working again but this has never been an issue in the past.
Also, when I create a new snippet and save, it gives me some error message but ultimately saves the snippet.
Please send an update to the update
Can you confirm if the issue persists on 10.13.13 as there were some fixes here.
To resolve this you will need to trust the server certificate upon connection within SSMS.
I am also experiencing this issue using v10.13.16.3650 of SQL Prompt;
using in SSMS v19.156.0;
connecting to Azure DBs via "Azure Active Directory - Universal with MFA"
I do have "Trust server certificate" checked.
[EDIT: After restoring all SQL Prompts settings to default and closing/restarting SSMS, magically, things started working again]
Encrypting the connection and selecting the trust certificate did not work for me. I also don't get any snippets.
I'm running version 10.14.2.54417.
I'm getting the same after the latest upgrade...
2023-12-05 17:51:14.335 +00:00 [Information] Launching package entry point Ssms18 (version 15.0.18424.0) for SQL Prompt 10.14.3.4664.
2023-12-05 17:51:16.133 +00:00 [Information] SqlPromptApplication initialised (startup took 0:0:0.0)
I've set both encrypted and trust server certificate to no avail!
Thanks, Dr. Michael Dye.
I updated to 10.14.6.5992 yesterday and my suggestions stopped for Azure Synapse (PDW) databases. Also hangs when suggestion load is trying to connect to 'master'.
Any help is appreciated. Below are log entries.
No suggestions and the refresh suggestion box gets stuck on "Connecting...".
Working on SSMS 18.12.1 and with SQL Prompt version 10.14.12.7945.
The earlier provided suggestion on connection options doesn't resolve the issue for me.
setting the option of "Trust server certificate" made no difference.
setting the option of "Encrypt Connection" made no difference, apart from making things slow.
setting both "Trust server certificate" and "Encrypt Connection" made no difference.