LoginMode Value | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

LoginMode Value

Based on my experience with Management Studio: The LoginMode Value 0 is not exactly like 2. If LoginMode is 0, the server authentication area is disabled so you cannot change authentication. Peter

Are you trying this on SQLEXpress or MSDE? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Hi Satya, I tried this on any instance MSDE/Express/2000/2005 instance in both SSMS/SSMSE.
Peter
]]>