Login Creation and Maintenance

To create a login, follow these steps:

1. Right-click on the Security icon and select New Login from the right-click menu. The Login Properties dialog box appears.

2. Enter a login name in the Name text box or use the Browse button to select a group or group member from the = 4) BSPSPopupOnMouseOver(event)" CLASS="BSSCPopup">Windows Members dialog box.

3. In the Authentication section of the dialog box, select the type of authentication.

• Windows Authentication -- Relies on Windows NT/2000 to authenticate the users login credentials. Select this option to automatically use your Windows login. Select the primary domain from the Domain list.

• SQL Server Authentication -- Relies on Microsoft SQL Server to perform the login validations. Select to specify a login other than the Windows login. Enter a user name and password. The password is optional, depending on your Microsoft SQL Server settings.

• Allow Access to TRAVERSE -- Clear to remove a group or group member’s access to TRAVERSE.

4. In the Database Permissions box, select the company database check boxes to which you want the group or group member assigned. For more information on groups, see Groups and Users.

   Click All to select all listed company databases. Click None to deselect any company databases currently selected. Once you select a company database check box, the Database Roles list box displays all the available roles/groups.

5. Select the groups to which you want the group or group member to be assigned.

   Note: Public is checked and required for all.

6. Click the = 4) BSPSPopupOnMouseOver(event)" CLASS="BSSCPopup">Server Roles tab to define the function of a user such as administrator, backup operator, database creator, and so on.

The security measures in Microsoft SQL Server include several predefined roles with implied permissions. If you have users who require these permissions, you must add their accounts to these predefined roles. Fixed server roles, which cannot be created, are defined at the server level and exist outside of individual databases.

7. Select the predefined roles you want to assign to the new login. A brief role definition appears in the list box near the bottom of the window.

8. Click Apply to create the new login. Once the login is created, the cursor appears in the Name text box for creating another login.

Click OK to create the new login and return to the Server Manager main window. Click Cancel to cancel the action and return to the Server Manager main window.