Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
real_pearl
Posting Yak Master
106 Posts |
Posted - 2005-02-10 : 06:12:15
|
I want to know is there a way we could find out which authentican mode is set for the server. A procedure or any API. I actually want to get this info at front end. I am using C#. |
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2005-02-10 : 06:47:45
|
The way I know of is to look in the registry of the server machine. In the MSSQLServer key, there is a value called loginmode. This is 1 if integrated only, and 2 if mixed.You can read it from the SQL Server using the extended proc xp_regread./Andraax |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
real_pearl
Posting Yak Master
106 Posts |
Posted - 2005-02-10 : 07:04:23
|
Thanks, This is what I wanted to know. |
|
|
real_pearl
Posting Yak Master
106 Posts |
Posted - 2005-02-10 : 07:05:32
|
Thanks Andraax |
|
|
|
|
|