How do you determine MSDE authentication type
I had a question about a setup of MSDE as to what kind of authentication type an MSDE install had. I trolled through a bunch of Microsoft Support Knowledge base articles until I found This one regarding MSDE security.
Its interesting that the configuration is in the registry rather than in SQL server itself. Take a look at HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode and if you installed MSDE as a named instance then it would be HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name \MSSQLServer\LoginMode.
The values possible for this key are 1 for Windows Authentication only, 2 for mixed mode and prob 0 for SQL server auth only.
0 Comments:
Post a Comment
<< Home