Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant

Configuring Server Roles

Server roles set server-wide administrator privileges for SQL Server logins. You can manage server roles by role or by individual logins.

Assigning Roles by Login

To assign or change server roles for a login, follow these steps:

1. Start SQL Server Management Studio. In Object Explorer view, connect to the appropriate server, and then work your way down to the Security folder.

2. Expand the Security folder and the Logins folder to list the current logins. Right-click a login, and then select Properties to display the SQL Server Login Properties dialog box and view the properties of the login.

3. Select the Server Roles page, as shown in Figure 8-3.

   Figure 8-3. The Server Roles page of the Login Properties dialog box

4. Grant server roles ...