How to Create Windows Group Authentication Login in SQL Server 1. Prerequisites The users and group must be exist in Active Directory By using Windows Authentication, Windows groups can be created at the domain level, and a login can be created on SQL Server for the entire group. Managing access from at the domain level can simplify account administration. 2. Using SSMS (GUI)

1
2
3

The users and group must be exist in Active Directory

By using Windows Authentication, Windows groups can be created at the domain level, and a login can be created on SQL Server for the entire group. Managing access from at the domain level can simplify account administration.

2. Using SSMS (GUI) 3. Using T-SQL USE [master] GO CREATE LOGIN [SQL\SQLSERVER_RO] 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.

1
2
3
4

USE [master]
GO
CREATE LOGIN [SQL\SQLSERVER_RO] 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.