Judith Barer <> wrote: > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Alan Bourke > Sent: Monday, February 26, 2007 11:48 AM > To: [EMAIL PROTECTED] > Subject: Re: sql server connection > > Judith Barer wrote: >> 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. > > > So I would assume that if you want to connect from a web site you > should use sql auth because you do not want to assume the user is > using windows. I am using sql server express 2005 and I would like to > use sql auth but I can't figure out how to set the password. If you > used window auth when you installed how to do change it and set the > password?
Actualy your Web presence talks to your SQL, nobody else SHOULD. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "A good way to judge people is by observing how they treat those who can do them absolutely no good." ---Unknown http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.4/702 - Release Date: 2/25/2007 3:16 PM _______________________________________________ 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.