Cause
——-
SQL cluster dependencies was missing in cluster node
Resolution
=======
Installing MOM 2007 need to have dependencies criteria met.
In my case disk dependencies are not there so added the disk to the SQL Service Dependency list and OpsMgr 2007 installation went successful.
The install was failing due to a dependency missing on the SQL Service in the Cluster group. In cluster administrator I took the SQL Group offline and then clicked on properties of SQL server, then the dependencies tab and checked whether all disks are listed here.
Only Network name was there as I has added a new SAN disk to the group for the Data Warehouse database.
Now for SQL Server we should have minimum of two dependencies
1. Disk Physical Disk
2. SQL Network name (IP address)