I understand that you are experiencing issues installing Windows* 7 on a Cavalry* Solid-State Drive using an Intel(R) Desktop Board D945GCLF2 and a Intel(R) Desktop Board D510MO.
In regards to your inquire, I can confirm that both motherboards will be able to utilize Solid-State Drives that meet the SATA 2.0 standard to install the operating system. Unfortunately we don't have any additional reports of issues like yours with other brands of Solid-State Drives.
Windows* when not able to recognize a suitable storage device will promp you to load drivers for a SATA controller, this seems to me like Windows* is not able to recognize the drive. I recommend you to contact the manufacturer of the Solid-State Drive and request for assistance as they may have received this error in the past.