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
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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.