SQL Server Performance Forum – Threads Archive
LoginMode ValueBased 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
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.