IBM Tivoli Composite Application Manager for Microsoft Applications, Version 6.3.1

Setting up the Microsoft SQL Server agent in a cluster environment

You can setup the Microsoft SQL Server agent in a cluster environment.

The IBM Tivoli Monitoring Installation and Setup Guide contains an overview of clustering.

The SQL Server and the Microsoft SQL Server agent both support multiple instances running on the same node. One agent does not interfere with another while running on the same node.

When the SQL Resource Group is moved from node to node, the server down situation event fires. This event is caused by the Microsoft SQL Server agent coming online faster than the SQL Server. When the SQL Server comes online, the event clears.

Do not use the Start and Stop Take Action commands for the Microsoft SQL Server agent because they conflict with the actions that are taken by the cluster server.

You can install and configure the monitoring agent in a cluster environment by completing any of the following steps:

Feedback