What are the versions of the SFW-HA management packs that are installed on the server SFW-HA nodes? Also, are you using the MOMHelper.exe utility, or the latest management packs which no longer uses this and installs the (I believe the name is) VCSOpsMgrIntergration service.
In general, to monitor SQL, we require at least 3 management packs to monitor SQL. Library (Symantec.VCS.Library.mp), Discovery (Microsoft.SQLServer.200X) and Monitoring (Symantec.SQLServer.200X.mp) management packs. The Library MP defines the types required for SQL monitoring. Discovery MP discovers the SQL objects on a machine and Monitoring MP monitors the SQL objects discovered by discovery MP. If you were not running SFW-HA, all these management packs are from Microsoft.
Now, when SQL is running under VCS, some of the discovery scripts of the Microsoft Discovery MP does not work and fails to discover the SQL objects under SFW-HA control correctly. This opens up a requirement to customize these scripts for VCS environment. Symantec SQL MP serves this purpose. Symantec SQL MP contains customized scripts which also works when SQL runs under VCS. When one imports the Symantec MP into SCOM Server database, it disables the original discovery and starts working with the customized discoveries. Once the SQL objects are discovered, Microsoft's Monitoring MP starts monitoring the SQL objects.
Below is an example scenario of what you should see:
SQL 2005 is clustered with VCS on Node1 and Node2. The lanman virtual name for SQL is VS.
Expected behavior:
•Node1 and Node2 should be seen under VCS State view.
•VS should NOT be seen under VCS State View.
•VS should be seen under SQL State View.
•VS should be discovered as Agent-less managed computer.
•All 3 computers Node1, Node2 and VS should be seen under “Windows Computer” / “Computers” view.
