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

3 comments:

  1. This video demonstrates best practices of creating user defined database 9apps roles, how to add users to newly created database roles, how to add database objects to a database role.

    ReplyDelete
  2. Bow windows can transform a room by creating a gentle curved extension. Affordable Window Repair

    ReplyDelete
  3. Thank you for sharing this informative tutorial! Creating Windows Authentication logins in SQL Server can be tricky, but your step-by-step guide simplifies the process GST Calculator. Looking forward to learning more from your SQL Server DBA tutorials.




    ReplyDelete