How Do I Reset Prompt's Connection Cache?

sagesmith

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

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

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

Tianjiao_Li

Hi @sagesmith

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

Does that answer your question?

Thanks!

sagesmith

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

Request #244724