Adding a Windows Based Login to SQL Server

Using Windows logins is a great way to leverage the investment in a Windows domain. Did you know that you can add domain users AND domain groups? Watch this short video from MVP Brian Kelley as he walks you through the very common task of setting up a Windows login within SQL Server.

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

mark dufault on 1/12/2009

This helps by showing me where to start and what I need to understand...keep up the good work.

Kevin Cole on 1/28/2009

The content is a bit slight. Could be improved by adding a few seconds of discussion to cover prospective errors and how to handle them. For instance, what do you do if you find you don't have the permissions you thought you did? or if you can't find the group you were after? Good, though.

Richard Dugovic on 2/17/2009

Great little video ... although I already knew how to add a user "generally", I had never seen how the user could be associated with a particular database. Thanks.

Greg Goodall on 3/16/2009

A bit vague

Anand on 3/25/2009

good

John O'Sullivan on 4/16/2009

excellent

datamama on 4/17/2009

would be better if rate of speaking was slower

Dipak Saha on 5/12/2009

Greate demo.

Anil Mahadev on 5/22/2009

Hi Brian, Could you show us an Active Directory example in a future Video. I have installed AD and tried adding users to the Domain, but still they cannot access it. Is there any way to get the users to access the SQL Server via Domain\User Login? Thanks Anil

Juan Lorenzoni on 5/22/2009

Great

Daren Lewis on 5/22/2009

Very clear and to the point. Good for traiining.

Leonard Peoples on 5/22/2009

Very Nice.

Balamurugan Shanmugasundaram on 5/22/2009

Good

Venkat Raju on 5/25/2009

Nice presentation!

Silpa on 5/26/2009

Helpful in creating user groups

venkat on 6/10/2009

Really Wonderful

Lou Gallo on 6/12/2009

This left me a little short since I don't know what rights were assigned to the WarehouseUsers group.

Jerry Higgins on 6/12/2009

This was very helpful! Thank you.

luther smith on 6/12/2009

Very clear

Steve Harris on 6/16/2009

good and concise information

Joe on 6/17/2009

Short and awesome demo about the security models.Please create videos on policy authentication.

UB on 7/20/2009

Thanks for the great work guys. Please have longer videos on more complex concepts, please.

Raghu on 8/14/2009

goog

01EFFB45CF on 1/13/2010

Nice. Groups are the way to go.