How can we help you today? How can we help you today?

How Do I Reset Prompt's Connection Cache?

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?
sagesmith
0

Comments

5 comments

Sort by
  • 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!
    Tianjiao_Li
    0
  • sagesmith
    Thanks Tianjiao! Sure. Before I do, am I confusing an SSMS context menu item with SQL Prompt? "Script Object as ALTER".
    sagesmith
    0
  • Tianjiao_Li
    Hi @sagesmith

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

    Does that answer your question?

    Thanks!
    Tianjiao_Li
    0
  • 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
    0
  • sagesmith

    Request #244724

    sagesmith
    0

Add comment

Please sign in to leave a comment.