What are the challenges you face when working across database platforms? Take the survey
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

Comments

  • Options
    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
  • Options
    Yes, indeed one of my many scripts was attempting to login as SA. Seems to me this behavior should be documented. :D
Sign In or Register to comment.