SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Download a free trial of SQL Backup now

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!

Duration:
4 mins 34 secs
Skill Level:
100
Rating:
4.25 out of 5
Publish Date:
December 15, 2008
SQL Server Login vs Windows Authenticated Logins Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of K. Brian Kelley
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...

References

There are no downloads or recommended reading links for this video

Comments
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.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions