tailieunhanh - mastering sql server 2000 security PHẦN 2

Một click vào một tên động cơ để mang đến Chi tiết về bảng điều khiển các thiết lập STD. Di chuyển chuột qua các bóng đèn ánh sáng nhiều hơn thông tin về The tiết lộ một thiết lập cụ thể. | Introducing SQL Server Security 13 Initial Services After the installation is complete you will notice several services added to SQL Server. Although some of these services do not directly affect security it is necessary to understand each of them in depth to understand the security analysis and recommendations of the coming chapters. The services added are as follows SQL Server Service MSSQLServer . The SQL Server service manages the databases owned by an instance of SQL Server. It is the component that processes all Transact-SQL statements sent from client applications. The SQL Server service allocates computer resources between multiple users. It also enforces business rules defined in stored procedures and triggers ensures the consistency of the data and prevents concurrency issues. SQL Server Agent Service SQLServerAgent . The SQL Server Agent service handles the automation of administrative tasks. Jobs operators and alerts are components of the SQL Server Agent service that provide the automation features. The SQL Server Agent service will be explained more completely in Chapter 9 Introducing the SQL Server Agent Service. Microsoft Distributed Transaction Coordinator MS DTC Service. This service is a transaction manager that allows client applications to include several different sources of data in one transaction. It coordinates committing the distributed transaction across all the servers enlisted in the transaction. Microsoft Search Service. The Microsoft Search service provides a full-text query engine enhancing the querying capabilities of the database to include proximity and full text searches that are not supported natively to ANSI-92 SQL. For more details on the Microsoft Search service see the SQL Server Books Online. When multiple instances of SQL Server are run on the same computer each instance has its own SQL Server service and SQL Server Agent service. The service name for the default instance is MSSQLServer and the service name for named .