Mixed Mode vs Windows Authentication Mode

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Vanecek (MikeV99_at_privacy.net)
Date: 10/07/04 

Date: 7 Oct 2004 07:47:16 -0500

When installing the server, one of the screens asks to choose between Windows
Authentication Mode or Mixed Mode (Windows Authentication and SQL Server
Authentication). What exactly does this do to the setup? It appears that
regardless of which option used, one can create a userid in Enterprise Manager
that is not a Windows userid and assign that userid as a db_owner. I am having
difficulty understanding what the difference in functionality is based on that
setting? Is this something that sp3a changes? 

-- 
  Thanks, Mike.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)