Changing the authentication mode for SQL Server 2000
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
Post Data
- Posted: Oct 18, 2006 by TechPedia
- Short URL: http://qte.me/1zc
Recent Comments