Managing Server Roles
Perform the following steps to grant a server role:
1. |
From the SQL Server Enterprise Manager, click the plus (+) sign next to the server that contains the login.
|
2. |
Click the plus (+) sign next to the Security folder.
|
3. |
Left-click the Logins icon. A list of logins appears in the Result pane.
|
4. |
Right-click the name in the Result pane. From the right-mouse menu, select the Properties menu option. The SQL Server Login Properties dialog box appears.
|
5. |
From the SQL Server Login Properties dialog box, click the Server Roles tab (see Figure 9.2).
Figure 9.2. The SQL Server Login Properties dialog box—Server Roles tab.
|
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
