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

Resetting the database connections

Hi,
I installed SQL Prompt 7 and every once in a while I get a message that the suggestion refresh failed. It appears to be trying to login with the SA account. How do I update the utility to just use Windows Authentication?

Thanks,
Tony
runamuk0
0

Comments

2 comments

Sort by
  • David Priddle
    Hi Tony,

    Auto Refresh will go through all of the SQL scripts that you have open, take the connection from each one and do the refreshing in the background.

    Could there be a script that's open that has been connected to the database as SA?

    Best regards,

    David
    David Priddle
    0
  • runamuk0
    Yes, indeed one of my many scripts was attempting to login as SA. Seems to me this behavior should be documented. :D
    runamuk0
    0

Add comment

Please sign in to leave a comment.