Unknown authentication type

• Venkatesan Prabu

  SSCommitted

  Points: 1892

  More actions

  September 13, 2010 at 7:55 pm

  #226814

  While working on Policy based managements, I found an option unknown in the authentication mode.

  I have heard windows/mixed and sql server authentication. Whats this unknown authentication type. Any thoughts from experts.

  Cheers,

  Venkatesan Prabu .J

  http://venkattechnicalblog.blogspot.com/

  --------------------------------------------------------------------------------

  Thanks and Regards,
  Venkatesan Prabu, 😛
  My Blog:

  http://venkattechnicalblog.blogspot.com/

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  September 13, 2010 at 9:36 pm

  #1220420

  AFAIK, there is no other method. Perhaps its' an error? Can you give more details about what you mean about finding a new mode? Where? What context?

• Ali Tailor

  Hall of Fame

  Points: 3769

  More actions

  September 15, 2010 at 1:14 am

  #1221144

  I'm agree with Steve Jones - Editor

  Regards

  Ali Tailor

  Ali
  MCTS SQL Server2k8

• arun.gopinath

  SSC Enthusiast

  Points: 161

  More actions

  September 22, 2010 at 2:11 am

  #1225372

  http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/09/15/policy-based-management-and-the-unknown-loginmode.aspx

  http://sqlblog.com/blogs/tibor_karaszi/archive/2010/09/15/watch-out-for-old-stuff.aspx

  (I guess your question was already answered on MSDN forums, I thought it would be cool to share them with SSC readers! 🙂 )

  Cheers!!

• subbu_e

  SSCrazy

  Points: 2431

  More actions

  September 23, 2010 at 2:04 am

  #1226133

  you can also refer the following to get more details on authentication

  http://support.microsoft.com/kb/326985

  Regards,
  Subbu
  Click here to Get Speedy answer or solution

• Venkatesan Prabu

  SSCommitted

  Points: 1892

  More actions

  September 23, 2010 at 2:12 am

  #1226136

  It's not a bug. Sometimes, if the authentication mode is goofed up (it's just a configuration in the registry) by the sys admin people.

  Your sql server won't be part of all the three modes of authentication.

  This option is used to find the same.

  Thanks to all for your precious time. By next week, I will write a detailed article in my blog.

  Cheers,

  Venkatesan Prabu .J

  http://venkattechnicalblog.blogspot.com/

  Thanks and Regards,
  Venkatesan Prabu, 😛
  My Blog:

  http://venkattechnicalblog.blogspot.com/