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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to identify Authentication Mode

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
Go to Top of Page

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2005-02-10 : 06:55:23
I think it's better to use xp_instance_regread, since it deals also with, guess what, instances.
See if this helps: http://www.sqldev.net/misc/SQLLocationFunctions.htm

--
Frank
http://www.insidesql.de
Go to Top of Page

real_pearl
Posting Yak Master

106 Posts

Posted - 2005-02-10 : 07:04:23
Thanks, This is what I wanted to know.
Go to Top of Page

real_pearl
Posting Yak Master

106 Posts

Posted - 2005-02-10 : 07:05:32
Thanks Andraax
Go to Top of Page
   

- Advertisement -