Re: SQL Server Mode


A few notes from BOL:

"Windows Authentication Mode is much more secure than Mixed Mode"

"Windows Authentication utilizes Kerberos security protocol, provides
password policy enforcement in terms of complexity validation for strong
passwords, provides support for account lockout, and supports password
expiration"

"Security Note: When possible, use Windows Authentication"

"SQL Server Authentication is provided for backward compatibility only. When
possible, use Windows Authentication"

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica



"George Schneider" wrote:

what do you mean it depends on what we are doing and how?

We run several db's fro everything from our fax server to our web site db
how can i determine which is best.

how is windows more secure than mixed mode?

"Andrew J. Kelly" wrote:

Windows is generally more secure but which is better depends on what you are
doing and how.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"George Schneider" <georgedschneider@xxxxxxxxxxxxxxx> wrote in message
news:D540F786-37EE-42A2-BF72-9ACDA9E01E4E@xxxxxxxxxxxxxxxx
IS it better to use mixed mode or windows authentication mode? Which
method
is more secure?


.

Relevant Pages

  • Re: Forms Authentication & SSL
    ... Have you disabled basic and windows authentication on your web application ... it's not secure, redirect to itself as secure? ... > But if the tag reads ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • ASP.NET Authentication and Windows Authentication
    ... Windows Authentication, so users can access the application without the need ... of filling out a login page. ... According which user is using the web app, he/she'll have a dinamic menu, ... who is accessing the web app, and how to make it secure. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Using Windows Security
    ... Windows Authentication is more secure in nature. ... Books Online for SQL Server SP3 at ... How can I use these local tools to access ...
    (microsoft.public.sqlserver.security)
  • Re: Secure Website
    ... Basic is probably better than Windows authentication, ... work through proxy servers and firewalls.... ... and then use any practical login method that you want. ... Integrated Windows Authentication is more secure, ...
    (microsoft.public.inetserver.iis.security)
  • Re: msde login problem
    ... MSDE is installed with Windows Authentication only. ... trusted logins. ... To change to mixed mode you have to change a ... Description = Login failed for user 'sa'. ...
    (microsoft.public.sqlserver.server)