Each physical node has to have “Agent Proxy” enabled (in the administration tab -> Agent managed)In case this was not set, restart the agent on each cluster node. The discovery reruns. Check now that each virtual node comes in under “agentless” managed. (in the discovered inventory it will show as “not monitored” which is ok)Now check under Windows Server (state view). Each virtual server has to be discovered. Check the properties, it has to say “Is Virtual Node” true. Now the SQL 2005 should work as well. Check the SQL state views (this may take a moment if the Virtual node was not discovered previously – again you can restart the agent on the cluster node where the SQL is currently active)
Here is a Step-by-step guide on exactly what to do.
- Open System Center Operations Manager Operator Console.
- Open the Administration view, and select Agent Managed under Device Management.
- Right-Click on the Cluster Nodes and select Properties.
- In the security tab tick the box that says Allow this agent to act as a proxy and discover managed objects on other computers.
- Click OK.
- On the Cluster Nodes restart the OpsMgr Health Service. (The Discovery will re-run)
- Open the Administration view, and select Agentless Managed under Device Management.
- You should see all the Cluster Virtual Servers.
- Open the Monitoring view, and select Discovered Inventory. It will show “not monitored” this is expected.
- Select Windows Server State under Microsoft Windows Server. (You should see the Cluster Object listed with their IP address).
- Right-Click the Cluster Virtual Servers select Properties.
- Check that the line saying “Is Virtual Node” is True (The SQL 2005 MP should work now)
- Select Database State under Microsoft SQL Server\Databases. (This may take a moment if the Virtual Servers were not previously discovered. You can re-start the OpsMgr Health Service where SQL is currently active to rescan).