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

In this video you will learn how to create SQL Server Login using Windows Authentication. It also demonstrates step by step process of creating Windows Authentication Login using SQL Server Management studio as well as T-SQL Script. It also explains how to retrieve Active directory user, options while creating Windows Authentication user such as selecting right object type, selecting right domain controller as well as selecting entire directory to create SQL Server Login using Windows Authentication.

Script used in this video to Create Windows Authentication Login

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



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