How to Grant User / Group Access to SQL Server Database



Share this article :

1. Open the SQL Server Management Studio. Navigate to the following tree, Security > Logins. Then, right click and select New Login.

SQL - New Login

2. Click on Search > Object Types and  check on Groups box. By default, the Groups box is unchecked.

Object Type - Group

3. In General page, enter the login name. If you are in domain network, please put the domain name as well. The login name is applicable for both user and group. Accept the default values as per screenshot.

General - Login name

4. In Server Roles page, define to which server roles are required.

Server Roles - SQL

5. Next, in User Mapping page, define the mapping for the login.

User Mapping - SQL

6. Leave the Securables page as default.

Securables - SQL

7. Accept the default as well in Status page. Once done, you may click OK to activate the new access.

Status - SQL

Tags:

Related posts

Start, Stop, Restart, Pause & Resume SQL Server Agent
SQL Server Native Client Installation Steps
Enable SQL Server Database to Read Only & Read/Write
Rename MSSQL Server Database
© 2017 ITsiti. All Rights Reserved
Powered by KEEM