For some reason, a recent install of SQL server 2000 wouldn’t let me change from Windows authentication to ‘mixed mode’, even from within the management console.
A few minutes of googling led me to the following, replicated here for posterity:
To change the mode via the Registry, change the ‘LoginMode’ value in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer to one of the following values:
1 = Windows Only
2 = SQL Server and Windows
0 comments for this entry ↓
There are no comments yet for this entry.
You must log in to post a comment.