You are a database administrator for AIOTestKing.com. You are configuring a new SQL Server 2005 computer named AIOTestKing A. AIOTestKing A will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to AIOTestKing A will be made by using AIOTestKing As DNS name. You need to disable any unnecessary services on AIOTestKing A.
Which service or services should you disable? (Choose all that apply.)
A.
Microsoft Distributed Transaction Coordinator
B.
Internet Information Services
C.
SQL Server Agent
D.
SQL Server Browser
Explanation:
IIS 5.0 or later is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations. SQL Server Agent is a Microsoft Windows service that allows you to automate some administrative tasks like backups and maintenance tasks. SQL Server Agent runs jobs, monitors SQL Server, and processes alerts. The SQL Server Agent service must be running before local or multiserver administrative jobs can run automatically. Microsoft Distributed Transaction Coordinator is used mainly for clustering SQL Servers. SQL Server Browser is needed when you use named pipes to connect to a specific instance on the SQL Server.