How to grant a SQL Server login access to a database (Enterprise Manager)

To grant a SQL Server login access to a database

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database to which the login will be granted access.
3. Right-click Users; then click New Database User....
4. In Login name, click the Microsoft® SQL Server™ login to which database access will be granted.
5. Optionally, in User name, enter the username that the login is known by in the database. By default, it is set to the login name.
6. Optionally, select database role memberships in addition to public (default).

See Also