Resetting the database connections

runamuk0@msn.com

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

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

runamuk0@msn.com

Yes, indeed one of my many scripts was attempting to login as SA. Seems to me this behavior should be documented.