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.