> > When connection to SQL server is using Windows authentification just as > > secure as using sql server authentification? What are the advantages of > > each one?
> With Windows auth you need to have a valid domain login already set up, > with SQL auth you just need a username and password. Yes-- windows authentication needs a valid windows account. Accessing locally, that can be a local account-- in a network environment, that must be a domain account, an account on a trusted domain, etc. Simply put, windows authentication is usually a pain in the a$$ unless you already have a domain setup. I almost always use sql auth instead of windows integrated... As for security, any MSSQL traffic should only be done over a secured network connection(lan, VPN, etc.) anyways. -- Derek _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
