Update has caused Prompt to stop working

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.

jcbaker August 01, 2023 15:19

0

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

ATurner August 01, 2023 16:06

0

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.

jcbaker August 01, 2023 16:26

0

Using Windows Authentication and not hosted locally.

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

lboudreaux August 01, 2023 16:57

0

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.

NSRjecross August 03, 2023 08:21

0

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

challman August 03, 2023 16:27

0

Hi All

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

ATurner September 07, 2023 11:36

0

Hi All

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

ATurner September 19, 2023 18:20

0

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.

Bostaevski October 02, 2023 20:57

0

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]

EricZ November 03, 2023 12:42

0

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

Jim_Mc November 09, 2023 03:42

0

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.

mjninc November 28, 2023 12:59

0

Hi all,
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)

2023-12-05 17:51:36.168 +00:00 [Information] Sql History initialized successfully

2023-12-05 17:51:37.970 +00:00 [Information] Created new ServerCandidate for server: XYZ

2023-12-05 17:51:38.234 +00:00 [Warning] Failed to load server XYZ

Microsoft.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.)

I've set both encrypted and trust server certificate to no avail!

Thanks, Dr. Michael Dye.

michaeldye December 05, 2023 17:54

0

Hello! Another victim of the latest update.

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.

ClientConnectionId:37e03af8-c660-48e1-85cb-7bb5cf73f975

Error Number:104385,State:1,Class:16

2024-01-30 10:21:15.654 -05:00 [Information] Chosen server capabilities "PDW"

2024-01-30 10:21:15.654 -05:00 [Information] Server does not support getting list of collations

2024-01-30 10:21:15.931 -05:00 [Information] Server does not support linking to other servers

2024-01-30 10:21:15.931 -05:00 [Information] Login suggestions are not supported for "PDW" servers

2024-01-30 10:21:15.998 -05:00 [Warning] Couldn't populate resource pools.

Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'resource_governor_resource_pools' is not supported in this version.

at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()

at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader()

at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.PopulateResourcePools(SqlConnection serverLevelConnection)

ClientConnectionId:f1bfe488-033f-4a6c-8a11-a64c7bd8086a

Error Number:104385,State:1,Class:16

2024-01-30 10:21:16.138 -05:00 [Warning] Failed to load server a*************v.database.windows.net

Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'dm_xe_object_columns' is not supported in this version.

at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()

at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader()

at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.GetPackageFromDatabase(SqlConnection serverLevelConnection)

at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()

ClientConnectionId:f1bfe488-033f-4a6c-8a11-a64c7bd8086a

Error Number:104385,State:1,Class:16

JPSpivey_AmWins January 30, 2024 15:25

0

Experiencing the same issue.
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.

RobertZ April 05, 2024 11:53

0

I'm seeing the same error after updating to 10.14.12.7945.
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.

marthinus April 05, 2024 13:54

0

For me this was solved by downloading the SQL Toolbelt Essentials installer from the RedGate website to update all packages. SQL Prompt itself did not need updating, but the overall Toolbelt update did resolve my issue with Prompt.

RobertZ April 08, 2024 07:42

0

Restoring defaults under Suggestions -> Behaviour worked for me

SueD July 31, 2024 03:20

0

I have SQL prompt version 10.14.21.9884 with this issue. "loading ..."

gsrinivasarao September 05, 2024 21:24

0

RobertZ said:

For me this was solved by downloading the SQL Toolbelt Essentials installer from the RedGate website to update all packages. SQL Prompt itself did not need updating, but the overall Toolbelt update did resolve my issue with Prompt.

Thanks for this. This resolved it for me too after trying the other posted suggestions.
Downloaded toolbelt essentials installer from: https://www.red-gate.com/products/sql-toolbelt-essentials/entrypage/latest-essentials

Then updated the products that were flagged with updates (ignored any which would have triggered new trials).

Working again now thankfully!

tonywaddle October 17, 2024 13:36

0

tonywaddle said:

RobertZ said:

For me this was solved by downloading the SQL Toolbelt Essentials installer from the RedGate website to update all packages. SQL Prompt itself did not need updating, but the overall Toolbelt update did resolve my issue with Prompt.

Thanks for this. This resolved it for me too after trying the other posted suggestions.
Downloaded toolbelt essentials installer from: https://www.red-gate.com/products/sql-toolbelt-essentials/entrypage/latest-essentials

Then updated the products that were flagged with updates (ignored any which would have triggered new trials).

Working again now thankfully!

This worked for me too, thanks for posting a link!!

brownyredgater November 15, 2024 02:51

0

Update has caused Prompt to stop working

Comments

Add comment

How can we help you today?

Update has caused Prompt to stop working

Comments

Add comment