Đang chuẩn bị liên kết để tải về tài liệu:
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P36

Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P36: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Managing Security Chapter 4 157 1. Open up the SQL Server Configuration Manager. 2. Click on SQL Server Services as in Figure 4.14. 3. Right-click on SQL Server Agent and click Properties. 4. In the properties window on the Log-on tab click on the drop-down menu for Built-in account and take a look at the available accounts. 5. Now take a look on the Service tab and locate the Start Mode. Remember that at the time of install this service is disabled. This is where you would change the Start Mode in order to enable SQL Server Agent. 6. Select the Cancel button to exit Properties. 7. Exit the SQL Server Configuration Manager. Domain Service Accounts versus Local Service Accounts There are a few restrictions to which account types can be used by SQL Server services. There are a couple things to consider when selecting an account type to use with a SQL Server service. If the service must access file shares or use link server connections to other SQL servers using a minimally privileged Domain user account is the best option. The Local service account is a built-in account with the same level of access to resources and objects as members of the Users group. The limited access of the local service account can help safeguard the system if individual services or processes are compromised. You cannot use a Local Service account for SQL Server or SQL Server Agent. 158 Chapter 4 Managing Security Summary of Exam Objectives The key to securing SQL Server is understanding the security hierarchy and the elements involved. The security of how principals connect to SQL Server and how the numerous features that require access to resources beyond SQL Server should be managed using The Principle of Least Privilege. SQL Server security is managed through Logins Database users Server-level Roles Database-level Roles and the service accounts needed by the various SQL Server features. It is very important to carefully consider the level of permissions needed for each user and establish .