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. PeterAre 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
]]>