SQL Server DBA Tutorial 50- How to create Windows Authentication Login in SQL Server

preview_player
Показать описание
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.

link to blog post:

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

awesome video..why in some organization they disable public...can u give a scenario plz.. thanks

tushibhaque
Автор

what if the the windows user need to access all the db inside in order to do backup..need to set default database 1 by 1 or just set to master?

decentpuppet
Автор

How To Enable Windows Authentication In SQL Server

In my case is Disabled
But i also lost SA Password

royalfamily