MSDE -> Mixed Mode
-------------------------
If you want mixed security, you can install MSDE like so:
d:msdesetup.exe SECURITYMODE=SQL
-------------------------
Below is for a named instance: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServer
Key name is LoginMode. Three legal values 0,1,2. This is a carry over from 6.x days. 2 seems to mean mixed. You better test whether "Windows only" should be 1 or 0.
2:18:50 AM
|