Creating server logins for users and groups (Model Explorer)
You can create a Server login for an Active Directory user or group. Logins are used for SQL Server authentication. To allow users or groups to connect to the SQL Server instance, you must create a server login for each user and group that you want to give database access to.