Impact of Changing Authentication Mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Suhas Vengilat - 21 Sep 2005 13:49 GMT

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

Reply to this Message

Joe Yong - 22 Sep 2005 03:01 GMT

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.

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks in advance
> Suhas

Reply to this Message

Keith Wilson [MSFT] - 06 Oct 2005 00:09 GMT

With either SQL Server 2000 or SQL Server 2005, the process is virtually
identical as follows:

Run SQL Enterprise Manager (or Start > Run > SQLwb.exe if using 2005)
Connect to the server
Launch Server Properties dialog
Switch to the Security tab
Select the Authentication option (Mixed or Windows only) > OK
Dismiss the "restart the server to implement changes" message box
"Restart" the MSSQLServer service (Start > Run > Compmgmt.msc >
services.msc)

Regards,
Keith

This posting is provided "as is" without inferring rights or warranties.

> One extra door to guard?
>
[quoted text clipped - 16 lines]
>> Thanks in advance
>> Suhas

Reply to this Message