# Create SQL Server Login

Published 2022-12-03

This tutorial explains to you how to create a SQL Server login. This article has a step-by-step approach.

What is the difference between a SQL Server Login and SQL Server User ?

SQL Login is for Authentication and SQL Server User is for Authorization. Authentication can decide if we have permissions to access the server or not and Authorization decides what are different operations we can do in a database. Login are created at the SQL Server instance level and User is created at SQL Server database level. We can have multiple user from different database connected to a single login to a server.

You can create a Microsoft SQL Server Login using the SQL Server Management Studio.

The steps for creating a Login for SQL Server Database.

First connect to the Microsoft SQL Server Management Studio :

Right click on "Logins" choose "New Login ...". You will see the following page:

Choose login name and "SQL Server authentication". Click on "OK".

Grant server-wide security privileges to this Login. Click on "OK".

Map if you have/ want users to this Login and click on "OK".

For the moment you can click on "Next".

Let the default settings or change them and click on "OK".

Here is the new Login created in SQL Server 2016.