topic server connection problem - "Use trusted Connection" in QlikView

server connection problem - "Use trusted Connection"

Wed, 03 Aug 2011 21:02:00 GMT

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?

server connection problem - "Use trusted Connection"

Wed, 03 Aug 2011 21:17:03 GMT

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

server connection problem - "Use trusted Connection"

Tue, 09 Aug 2011 23:02:17 GMT

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.