Đ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- P23

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P23: 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. | 92 Chapter 3 Configuring SQL Server 2008 Managing Services Launching Configuration Manager connects you to the local server and displays all of the SQL Server Services installed locally. Figure 3.4 shows Configuration Manager after completing Exercise 3.1.You can see the two instances that are installed as well as the Analysis Services and Reporting Services installations and can start stop and restart the services by right-clicking on the appropriate instance. Figure 3.4 SQL Server Configuration Manager Note that the two SQL Server Agent Services are stopped and set to start manually. Right-clicking on a service and selecting Properties gives you access to four tabs the first of which allows you to change the account that the service logs on with. In Figure 3.5 you can see that SQL1 is currently running using the Network Service account and you can change it here to run using a dedicated Windows account. It s a Microsoft best practice for SQL Server to run using a dedicated Windows account. Configuring SQL Server 2008 Chapter 3 93 Figure 3.5 Changing the Service Account If you need to change the service account for any of the SQL Server services then this is the only supported method to do it. SQL Server Configuration Manager assigns additional advanced user rights to the accounts when the service is configured which won t get assigned if you just use the Services applet in control panel. The Service tab allows you change the startup type of the service to Automatic Manual or Disabled. They work the same way as any other Windows service but it s worth noting that if you are running SQL Server 2008 on a Windows failover cluster you will see all the services set to start manually. This is because the failover cluster software manages when the services get started and stopped they don t get started in the normal way by Windows during startup. They will be stopped on passive nodes and started on active nodes. The Advanced tab provides access to change whether or not .