Adding a New SQL Security Login for PT Administrators

This allows users who belong to the PT Administrators group to read and write to the Eval database.

To add a new SQL security login for PT Administrators

1. Click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager. The SQL Server Enterprise Manager appears.
2. In the Console Root pane, expand the Microsoft SQL Servers node and then expand the SQL Server Group node.
3. Expand the Server Name node, where Server Name is the name of your server.
4. Expand Security.
5. Right-click Logins and then click New Login.
6. Under the General tab, in the space to the right of Name, type the Domain\user, where user is either the group "PT Administrators" or the name you have chosen for your administrative group.
7. Next find the Defaults section located at the bottom of the page. Select Eval from the drop-down list in the Database field to specify it as the default database.
8. Click the Database Access tab. Select the check box next to Eval to specify it as a database that can be accessed by the new login. Then select db_reader and db_writer from the list of database roles that users of the new login can have for the Eval database.
9. Click OK to exit.