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.