server connection problem - "Use trusted Connection"

[#1]

I am having a problem in both Version 9 SR4 and in Version 10 SR2 connecting to a SQL Server 2005 database.  It will connect fine if it is the first connection but if I need to pull from a different database first and connect to it later in the script it will pop up an error message with a check-box of "Use Trusted Connection".  If you check this and click ok it will go ahead and connect and complete, but this is a problem when it is scheduled since it just hangs at this point waiting for input.  Is this a setting somewhere that I need to change so that it does this automatically?

[#2]

Hi, I have never run into that problem, but I guess you can bypass the message box by going into user preferences-> security -> Script

Regards

[#3 · Accepted solution]

Thanks Ivan, that helped, that didn't quite work but at least pointed me in the right direction. I poked around in both the user preferences and document properties without much success and then I finally found a setting on the script tab under "settings" called "Scramble User Credentials".  When I checked that box it quit giving me the pop-up error and connects to the database.