SQL Server Login vs Windows Authenticated Logins

SQL login or Windows? Maybe you've heard that you should always use Windows authentication - but do you know why? Or when you can't use Windows logins? Join SQL security expert Brian Kelley for a quick discussion of the pros and cons of each login type and you'll know the answers!

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Steve Harris on 1/12/2009

Very helpful and informative. Told me things I did not realize.

B2C7C8BB67 on 1/14/2009

a visual of adding logins and removing logins would have helped some

lisa on 1/14/2009

Rather dry listening, very hard to remain focused. I guess if the instructor would point his mouse to which points he was discussing it would be easier to follow along, but it seemed his topics were overlapping at times.

Anil Mahadev on 1/17/2009

Hi, Great Video! Is there a way to assign a specific user created by a .NET application prevent access a particular SQL Server Instance created by the Application, using Windows Authentication? For Example: I created user A that needs to connect to any instance of SQL Server, other than the Specified Instance. And also How does one revoke BuiltIn/Administrators from Accessing the specified instance. Thanks Anil Mahadev anil.mahadev@live.com

mpadigela on 1/25/2009

very useful

James Young on 1/30/2009

As I have said before I am new to SQL Server and your little tutorials are extremely useful to me, thank you for going to the trouble of putting these up on the web. Regards James Young

Richard Dugovic on 2/17/2009

While the video portion consisted of only one screen of bullet points divided into three categories, the audio portion was concise and to-the-point ... Great Video -- and Audio!

01EFFB45CF on 1/13/2010

Very factual. I want to know more about Windows AD groups.

Diana on 2/8/2010

Another situation where SQL Server logins are widely used is a "shared server". The host assigns a login to each customer; this login is the owner of the customer's database.

Carlos B. Vasquez on 6/22/2011

Well-Explained, Good job Brian...

Martin Miller on 6/22/2011

Good overview of SQL Server logins.

Tom Hamilton on 6/22/2011

Excellent - thanks

Michael on 6/22/2011

Not bad

mel on 6/22/2011

Nice to know the difference. Thanks for taking the time to educate us.

Mauricio Afanador on 6/22/2011

The most of the video was presenting a word pad document, it would've been better if it showed some samples, or at least a power point or any kind of diagram

Zarir Patel on 6/22/2011

Useful information, could help ease dba's job

RL Henson on 6/22/2011

Talks about Groups but does not provide a T-SQL example to query what Group a USER is in to provide additional options in SQL.

Jaycee on 6/23/2011

Nice summary of salient points!

ravi on 7/13/2011

worthy video

FE7E7E17E4 on 8/9/2011

Question about this: is active directory group authentication appropriate for sql express when the client is disconnected from the domain?

Maurice Ivory on 11/15/2011

Good information to know

Paul Tormey on 12/15/2011

The presentation isn't about a notepad/text screen display but about the choices of choosing which SQL user type. A very good explanation.