You have a System Center Operations Manager 2007 environment. Seven servers at your company host an accounting application that communicates with a Microsoft SQL Server 2005 database. When these servers lose connectivity to the SQL Server database, the accounting application service must be restarted. You need to be alerted when any accounting application server loses connectivity to the SQL Server database. What should you do?
A.
Create an OLE DB data source synthetic transaction. Target the transaction at the SQL Server database.
Configure the Root Management Server as the watcher node for the synthetic transaction.
B.
Create an OLE DB data source synthetic transaction. Target the transaction at the SQL Server database.Configure the accounting application servers as watcher nodes for the synthetic transaction.
C.
Configure a distributed application that contains the accounting application servers and the SQL Server database. Set the Health Rollup Algorithm to Worst health state of any member.
D.
Configure a distributed application that contains the accounting application servers and the SQL Server database. Set the Health Rollup Algorithm to Worst state of a percentage of members in good health state.