Overview

In SQL Server, unlike Oracle, you have 2 sets of accesses to the database if I can say so:

Login - Access to the server in general

Username - Access to a specific database

A login can have access to a particular database or all databases, depending on its rights. Because of that, generally a DBA has to create a LOGIN for each user who wants to use the database and a username per specific database. The DBA can do that, either via the GUI (SSNS) or via scripts:

Creation of a database

The creation of the database in MS SQL is straight forwards:

After a database is created, DBA can create a login and then username. Login is created on server level, where user is created on database level:

Login Creation

Login is single access to the server, usually it does not allow you access to any data. Login are used to ONLY connect you to the server.

User Creation

After the Login is created, we can create a user associated with that login as follows: