Windows Authenication vs. Mixed Mode

From: ImNorseGod (ImNorseGod_at_discussions.microsoft.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 06:13:06 -0800

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: Domain local groups not in tokens. Was: Confusing Effective Permissions for serviceConnectionPoi
    ... When you say pre-W2K authorization do you mean mixed mode? ... If so, mixed mode is only important for AD replication, if you don't have NT4 BDCs, you should be moved into native mode and then the scope of domain local groups will be on all domain members and not just domain controllers. ... Defending Security Infrastructures http://blog.joeware.net/2006/07/11/445/ ... I was using Domain local scope for my security groups. ...
    (microsoft.public.platformsdk.security)
  • RE: VS Authentication (mixed mode)
    ... The "mixed mode" has nothing to do with VS. ... You can setup "mixed ... mode" with your Enterprise Manager on an existing installation of SQL-Server. ... So it uses the windows authentication. ...
    (microsoft.public.dotnet.framework.aspnet)
  • distribution list in adc
    ... I have setup an adc from our exch 5.5 to AD. ... exchange 5.5 server are in our w2k domain in mixed mode. ... from exchange 5.5 into ad are migrated as universal distribution groups. ...
    (microsoft.public.exchange2000.setup.installation)
  • Re: Upgrading PDC from NT to Windows 2000
    ... If you do this upgrade, it will upgrade in Mixed Mode (i.e. NT domain ... AD will not be a factoruntil you switch the whole ... setup into Native Mode. ...
    (microsoft.public.win2000.active_directory)
  • Re: Upgrading PDC from NT to Windows 2000
    ... If you do this upgrade, it will upgrade in Mixed Mode (i.e. NT domain ... AD will not be a factoruntil you switch the whole ... setup into Native Mode. ...
    (microsoft.public.win2000.general)