Re: Impact of Changing Authentication Mode

From: Joe Yong (NO_jyong_SPAM_at_scalabilityexperts.com)
Date: 09/22/05 

Date: Wed, 21 Sep 2005 19:01:25 -0700

One extra door to guard?

Not sure what you mean by impact. From a performance or resource overhead
perspective? Nothing there. From a security perspective, you now need to
figure out how to manage the SQL Server logins to ensure they follow your
password policies (complexity, length, expiration, re-use, etc...). Not much
help built into SQL Server 2000 but in 2005, life gets a LOT better.

joe.

"Suhas Vengilat" <SuhasVengilat@discussions.microsoft.com> wrote in message
news:34F882D9-448F-4EDC-A62C-BB87CCAF9307@microsoft.com...
> Hi,
>
> Our application using an SQL 2000 database, which is currently using
> Windows
> Authentication. For some reason, we need to change the access mode to
> mixed
> mode. Could someone please throw some light on the impact of this change.
>
> Thanks in advance
> Suhas