Update has caused Prompt to stop working

lboudreaux

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 Server Management Studio 15.0.18424.0

jcbaker

This happened to me this morning. The loading box in the lower right no longer shows, and I have no suggestions from the database I'm in. ctrl+sft+d doesn't cause it to load.

ATurner

Hi All, what authentication method are you using to these servers? Also are they hosted locally? 

jcbaker

SQL auth, not hosted locally. I reverted to 10.13.10 and it's working again. I discovered when warning others at my company that they'd already experienced this.

lboudreaux

Using Windows Authentication and not hosted locally.

Just discovered I had to update my connections to select Trust Certificate and it works now.

NSRjecross

Same for me - ssms v18.12.1 and I'm no longer getting table prompts. When I do a refresh suggestions it pops up the server query window for just a fraction of a second (too fast to have actually worked). I've also tried disabling the labs beta features for auto refresh suggestions and  refresh intellisense suggestions automatically. Didn't seem to make a difference. Using windows auth to sqlserver 15.0.4
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.

challman

I'm having problems with the latest update. SnippetManager dialog hung and wouldn't allow cancel. I had to shutdown SQL server to get rid of it.
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 

ATurner

Hi All

Can you confirm if the issue persists on 10.13.13 as there were some fixes here. 

ATurner

Hi All

To resolve this you will need to trust the server certificate upon connection within SSMS.

Bostaevski

ATurner said:

Hi All

To resolve this you will need to trust the server certificate upon connection within SSMS.

Doesn't work for me.  Still not getting any suggestions to show up besides the default stuff.

EricZ

Any updates? 
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]

Jim_Mc

Encrypting the connection and selecting the trust certificate did not work for me. Still only get intellisense for snippits, no table column names.

mjninc

SQL Prompt Suggestions / Intellisense is not working for me when I hover over an object. I can still format however.

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.