How to Create Windows Group Authentication Login in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to add Active directory group to SQL Server, how to create login using Windows Authentication while selecting the active directory group. How SQL Server communicates with Active directory for Authentication and Authorization. What option to select when adding Active directory (AD) group to SQL Server Login. Video shows both ways of creating Group login, using SQL Server Management studio as well as T-SQL script.

Script used in this video to Create Windows Group Authentication Login in SQL Server

USE [master]
GO
CREATE LOGIN [TECHBROTHERS\SQLDBReader]  
FROM WINDOWS 
WITH DEFAULT_DATABASE=[master]
GO




SQL Server DBA Tutorial- Create Windows Group Authentication Login in SQL Server