Re: Windows Authenication vs. Mixed Mode

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 10:09:07 -0500

That's why you have multiple domain controllers. Also, if he can't log onto
the domain, he's off the air at that point. I've worked in secure
environments where they prefer that you can't login unless you've jumped
through all the hoops. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:evvVWOq5EHA.4040@TK2MSFTNGP14.phx.gbl...
Yes, but there are also disadvantages.
One is that If no domain controller is available for any reason, the user
cannot log on to the domain and the user will not be able to connect to SQL
Server.
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:eL2h57p5EHA.2180@TK2MSFTNGP10.phx.gbl...
> Windows authentication is superior because of such things as password
> expiry, password complexity, etc. can be managed by the domain policy.
SQL
> Server authentication can't do that currently.  Also, users don't have to
> remember a Windows password _and_ a SQL Server password.
>
> -- 
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
>
> "ImNorseGod" <ImNorseGod@discussions.microsoft.com> wrote in message
> news:2EDC5791-7B61-499B-BBB7-093903EA1F99@microsoft.com...
> Can anyone tell me why Authenication is the perfered way to way to setup
> security instead of mixed mode?
>
> I am new to the SQL Server enviroment, and in my opinion I would think
that
> mixed is the way to go.
>
> Any input would be great.
>
> Thanks
>

Relevant Pages

  • Re: Edit/Modify Stored Procedure in Management Console 2005
    ... said, though, regarding other programming environments (and I have over ... I worked with ever since I started to work with SQL Server 10 years ago. ... That is the way ISQL/W and Enterprise Manager in the 6.5 tools worked. ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Cost of ownership: MV vs. SQL Server
    ... >>> Licensing for SQL server on par with or lower than most MV ... I'm doing phone chats with people related to their production ... environments too so I'm not just theorizing on it. ... opinions on this matter for customers of this var, ...
    (comp.databases.pick)
  • MS SQL Server Database Administrator
    ... This position is for a senior Microsoft SQL Server DBA with between 3-5 ... years experience with production MS SQL Server environments. ... will support a variety of Centium MS SQL Server-specific solutions ...
    (comp.databases.oracle.misc)
  • Re: Multiple databases
    ... Instances provide better isolation from a security and environment ... > multi-instance SQL Servers except for dev and test environments. ... > Looking for a SQL Server replication book? ... >> Multiple instances of Sql server, ...
    (microsoft.public.sqlserver.server)
  • 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)