Microsoft SQL Server 2008 R2 Specifications download pdf (Page 58)

38 CHAPTER 2 Multi-Server Administration

3. On the General page, enter the name of a Windows user in the Login Name box.

4. Select Windows Authentication.

5. Click OK.

NOTE Unlike in the previous example, do not assign this user the sysadmin role on the

Server Role page. If you do, the user will automatically become a Utility Administrator

and not a Utility Reader on the UCP.

6. In Utility Explorer, connect to the UCP instance in which you created the login

(SQL2K8R2-01\Test2).

7. Select the Utility Administration node, and then select the Security tab in the Utility

Explorer Content pane.

8. Next to the newly created user (SQL2K8R2-01\Test2), as shown in Figure 2-8, grant the

Utility Reader privilege, and then click Apply.

FIGURE 2-8 Configuring read-only privileges for the SQL Server Utility

1 2 ... 53 54 55 56 57 58 59 60 61 62 63 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 58