How to create Windows Authentication Login in SQL Server

Table of Contents
___________________________________________________________________________________________________

1. Prerequisites
2. Using SSMS (GUI)
3. Using T-SQL
___________________________________________________________________________________________________

1. Prerequisites

The user must be exist in Active Directory

2. Using SSMS (GUI)

3. Using T-SQL

USE [master]
GO
CREATE LOGIN [SQL\david] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/