Unknown authentication type

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unknown authentication type

Unknown authentication type

Rate Topic

Display Mode

Topic Options

Author

Message

Venkatesan Prabu

Posted Monday, September 13, 2010 7:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205

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, :P
My Blog:

http://venkattechnicalblog.blogspot.com/

Post #985191

Steve Jones - SSC Editor

Posted Monday, September 13, 2010 9:36 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

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?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #985205

Ali Tailor

Posted Wednesday, September 15, 2010 1:14 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, October 25, 2012 2:19 AM
Points: 394, Visits: 869

I'm agree with Steve Jones - Editor

Regards
Ali Tailor

Ali
MCTS SQL Server2k8

Post #986053

aruopna

Posted Wednesday, September 22, 2010 2:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:43 AM
Points: 4, Visits: 358

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! Smile

)

Cheers!!

Post #990924

subbu_e

Posted Thursday, September 23, 2010 2:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, November 25, 2012 6:31 PM
Points: 1,375, Visits: 173

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

Post #991789

Venkatesan Prabu

Posted Thursday, September 23, 2010 2:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 15, 2012 7:06 AM
Points: 122, Visits: 205

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, :P
My Blog:

http://venkattechnicalblog.blogspot.com/

Post #991792

« Prev Topic | Next Topic »

Permissions