Step 1: Create Login in SQL Server for User Group

This section explains how to create a SQL server login for a user group.

1. Right-click on Logins and select New Login from popup menu.

   

2. Select Search, it displays a new window as Select user or Group.
3. Enter the user name and select Object Types.  For example, InnoUserGrp.
4. Select Groups in Object Types and select OK.

   

5. Select Check Names in Select User or Group window to verify the user name and select OK.
6. Select the default database as INW_PRDB. The newly added login is appears in the Object Explorer Details list.