Post reply

Trusted Connections in Live Environment

  • February 2, 2010 at 7:53 am

    #218809

    I have read some articles online saying never to use Trusted Connections in live environments. I have read others articles online saying that you should always use them, because the alternative is to use login and password stored in a connection string, which I don't like because they're easily found in the registry.

    What is the standard approach here?

  • February 2, 2010 at 8:11 am

    #1112297

    I'm not sure there's a standard. The recommendation from MS is to use trusted connections since you have a nice audit trail, and you can depend on AD for one single authentication source. If you go with SQL auth, the name/pwd tends to get shared more often.

    Lots of third party tools, however, don't let you use Windows auth, so for the the choice is made for you.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply