A Microsoft® SQL Server™ user account should be added to each database for each SQL Server login that requires access to the database (the same as adding a user account for a Microsoft Windows NT® user or group). If a user is not created in the database, the SQL Server login cannot access the database.
Important To grant a SQL Server login access to a database, the SQL Server login must already exist. This is different from Windows NT users and groups that can be granted access to a database before they are granted access to connect to SQL Server.
Windows NT groups allow multiple Windows NT users to be granted access to a database in one step, simplifying administration, whereas SQL Server logins must be granted access to a database one at a time.
To grant a SQL Server login access to a database