How to Create Login in SQL Server

In this article I am going to explain how to create Login in SQL Server.
  • 2055

Introduction

In this article I am going to explain how to create Login in SQL server. Login and password is used to provide better security to database. Using login and password, only authorized uses can access database. 

Steps to create login in SQL Server

Step 1 : Start SQL server :

Clipboard01.jpg

Step 2 : Expend Security and select Login  => Right click on Login and click on New Login :

Clipboard03.jpg

Step 3 :  Login dialog box appear, Here you need to put login name, password if you want to SQL server authentication. After enter all information click on OK button to complete the process:

Clipboard05.jpg

Step 4 : Now you will see that a new Login is created :

Clipboard07.jpg


© 2020 DotNetHeaven. All rights reserved.