Authentication Mode using T-SQL or SP...?

• Topher

  SSCommitted

  Points: 1763

  More actions

  January 23, 2008 at 3:27 pm

  #73960

  Is it possible to find what authentication mode a server is running using a t-sql command or SP on both 2000 and 2005..?

  -

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  January 24, 2008 at 6:12 am

  #771236

  Two ways that I know of ...

  1)

  SELECT ServerProperty('IsIntegratedSecurityOnly')

  1 = Integrated Security

  0 = SQL & Integrated Security

  2)

  EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode'

  1 = Integrated Security

  2 = SQL & Integrated Security