SQL Server Authentication Modes

Do you know your options for logging in (authenticating) to a SQL Server? Brian discusses the options and in later videos digs deep into the security choices we need to make to correctly secure our SQL Servers.

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

chandra sekhar on 3/16/2009

vsekhar06@gmail.com

Leigh Anne on 3/16/2009

I think the answers on the quiz portion are messed up. The second question should be SQL Server only. Even the explanation says so. However, it's scored wrong.

Venkat Raju on 3/16/2009

Awesome!!

dfortier on 3/16/2009

Speaker spoke too fast.

Wil Sisney on 3/16/2009

The quiz at the end of this video tracks the wrong answer for question 2. The proper answer is B, and the explaination text says the same, but the system thinks the proper answer is A. Please fix it!

Joe Crook on 3/16/2009

Good for the new SQL Manager

mit on 3/16/2009

Great work.. cheers..

janet macdonald on 3/18/2009

short, quick, informative

E5C2E26885 on 3/18/2009

Question #2 states what is "not" supported in SQL Server - the correct answer is "SQLServer Authentication Only"

Ozair Naqvi on 3/19/2009

Answer for 2nd question is wrong ... please check it :(

Rhonda on 3/21/2009

The video was good, the quiz at the end was wrong (question 2).

Andy Warren on 3/22/2009

Sorry about the question error, we're all too human sometimes!

Chacha on 3/25/2009

Thanks!

01EFFB45CF on 4/22/2009

glad to see the basics being taught in addition to the advanced stuff.

D151BB6B9F on 6/18/2009

I tried replicate his login to a dual login type server without a password and it did NOT allow me in. Clarification of that part was needed- a few more seconds on the topic might have cleared up my confusion.

Prasanna Prabhu on 6/20/2009

I wish your web-site supports a way to define the LEVEL of Audience b'cso this video was good but it was meant for Beginners..

Mark Sopczak on 6/22/2009

One tiny issue. If it is originally installed as WIN authentication and you switch to Mixed mode I believe the 'sa' password is then offically BLANK... a big security hole!!!!!

Emad on 6/23/2009

please we need more

ramu on 11/13/2009

Wow this video is very much help full for the novice great work for the test at the last

Josh Luedeman on 5/29/2010

Very informative and not dull. Would have done better on the quiz if I didn't have kids running in the house screaming.