Options

Resetting the database connections

runamuk0@msn.comrunamuk0@msn.com Posts: 12 Bronze 1
edited October 23, 2015 4:50PM in SQL Prompt
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
· Share on Twitter

Comments

  • Options
    David PriddleDavid Priddle Posts: 218
    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
    · Share on Twitter
  • Options
    runamuk0@msn.comrunamuk0@msn.com Posts: 12 Bronze 1
    Yes, indeed one of my many scripts was attempting to login as SA. Seems to me this behavior should be documented. :D
    · Share on Twitter
Sign In or Register to comment.