Adding a SQL Login to SQL Server

In this video for beginners, Brian takes you through creating a SQL Server Login and the different options available when creating the login. Brian covers the different options including password policies, user mappings and server roles.

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

Carol Raydon on 12/16/2008

i got a good grade on the test, so u do 2 I like the short ones, like this one, the best.

Stephen Oesterreicher on 12/16/2008

There are lots more to setting password in SQL server.

K. Brian Kelley on 12/16/2008

Agreed, there is a lot more to the password and to the login. However, this video was just to cover the basics of how to create a login for someone who has never done it before. Hopefully it met that goal.

Naresh M on 12/16/2008

its great video for beginers.thanks

Steve Harris on 12/16/2008

perhaps also explain securables

David Crooks on 12/16/2008

Very straight forward and well done based on that I passed the quiz.

86F32B4AAC on 12/17/2008

did not select default database AdventureWorks

David Roach on 1/9/2009

Too brief.

lisa on 1/20/2009

This trainer is the best at pointing out where he is going, what he is clicking on and why...Most Excellent Trainer!!!

James Young on 1/30/2009

I am trying to learn this suff since my SQL Sever database driven website has been attacked and at the moment the only way I can stop it is by making the database read only. Currently any user has full rights, which I know is totally wrong but you guys are putting me on the right track. Thanks again. Regards James Young

Anand on 3/25/2009

super

SAy Soukamneuth on 5/11/2009

good

raj on 12/26/2009

good

Ravi Raj on 6/29/2010

good one

Ludwig on 11/25/2010

Why do I need a login? Show how it plays together with a user on a db.

Eric on 4/29/2011

Excellent! To-the-point, clear, concise...just the way I like 'em! This video has all the qualities of the video that make sqlshare.com such a helpful site.

richard on 5/31/2011

Very simple intro works well

Rafael Copquin on 5/31/2011

It's very good and explanatory!!

kishanchandra golla on 5/31/2011

This video is awesome

Michelle Poolet on 5/31/2011

Might be a good idea to point out that every SQL login belongs to the "public" database role...could be a little confusing for newbies, especially if they try to uncheck it and find that they can't. Otherwise, good job!

Keith Cooper on 5/31/2011

good content and could understand the speaker!

manjeet on 6/1/2011

good one

Mike on 6/1/2011

would have loved just a little more insight into difference between a server login and a db user. Also comments on sql authentication vs windows would have been nice.

Sue Amin on 6/1/2011

explain what is covered under each role, such as data reader role, data writer role and why there is always public role that needs to be checked, would have helped understand it better. This is amazing for a newby like me. Many Thanks,

Subhash on 6/2/2011

This is really good to see & learn

Robert on 6/2/2011

so good....

Poonam Rane on 6/2/2011

short and specific.thanks

Man on 6/5/2011

Great if you can explain more on schema and the difference of role (when to use what)

John O'Sullivan on 6/15/2011

useful revision

Elmozamil on 7/6/2011

Thanks for your effort it really amazing to watch the video and then evaluate yourself about the important things discussed on the video. Elmozamil Elamir

Maurice Ivory on 11/2/2011

This was okay