How Do I Reset Prompt's Connection Cache?

sagesmith · January 16, 2021 3:47PM

SQL Prompt - At some point SQL Prompt cached a sql connection string that was encrypted but does not trust the server's cert (home made cert). When I want to use the Script Object as Alter feature it always fails to connect because of this. I've searched settings and registry. Does anyone know where this is?

Tianjiao_Li · January 19, 2021 3:40PM

Hi @sagesmith

We don't save any SQL Connection string once the SSMS is closed.

It will be really helpful if you could let us know what you are using for authentication, what SQL Server you connect to, what steps you are doing to reproduce it.

Thanks!

sagesmith · January 19, 2021 4:21PM

Thanks Tianjiao! Sure. Before I do, am I confusing an SSMS context menu item with SQL Prompt? "Script Object as ALTER".

Tianjiao_Li · January 22, 2021 1:51PM

Hi @sagesmith

The "Script Object as ALTER" is one of the SQL Prompt functions indeed.

Does that answer your question?

Thanks!

sagesmith · January 23, 2021 3:30PM

Ok. I'm going to submit a ticket with a link to a video showing my experience within SSMS. I'll post the ticket # here when I do.

sagesmith · January 23, 2021 3:40PM

How Do I Reset Prompt's Connection Cache?

Answers

Request #244724

Product Learning

Community Forums

Events & Friends

Simple Talk