March 2, 2009 at 9:01 am
This is probably a newbie question but what system stored procedure or dmv will return what current authentication mode is active on a given server?
March 2, 2009 at 9:22 am
It's stored in the Windows registry. Here's an article on dealing with the registry from within SQL:
http://qa.sqlservercentral.com/articles/Administration/3092/
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 2, 2009 at 10:08 am
I assume you are asking if the SQL Server instance is using Integrated Security or not, here is a simple query to accomplish that:
select serverproperty('IsIntegratedSecurityOnly')
1 = Integrated security
0 = Not Integrated security
March 2, 2009 at 11:50 am
That's what I was looking for. Thank you much!
March 2, 2009 at 11:51 am
You're welcome and thanks for the feedback.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply