Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos in Series Home  Subscriber Videos  

How to View Windows Logins in a Windows Group for a SQL Server Windows Login (Video Series)

Video Image Video Category: Security for SQL Server: Logins, Users, Roles and More

Skill Level: 400 (Intermediate - Advanced)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
Whew - what a title. The gist of this series is that you often have Windows Groups that are logins to your SQL Server and you want to know how to view the Windows users in that group. If you are the network administrator who is moonlighting as the DBA, no problem - just load up the ol' Active Directory and you can see it all. But what if your network privileges do not allow you to enumerate the users in a Windows Group?

This video series shows you the easiest way to view the users in a group that is a SQL login - a must-know for anyone who works extensively with Windows logins for SQL!

Videos in this Series:


Miscellaneous Bits & Pieces:
SQL Server 2000 Resource Kit - More Helpful Tools: DBManagement - the Database Management suite of tools feature the MMC and web front ends to your SQL Server
Security Tip: The "sa" account is probably best left unused in most organizations. Instead of using the "sa" account assign your Windows login to the "sysadmin" server role and use Windows Authentication to connect.
nslookup is a great command-line tool to diagnose DNS issues

Other Websites We Offer
LearnCSharp.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/6/2009 4:15:06 PM