SSD's behave like normal S-ATA drives, so no special hardware required.
You should however be aware of the limitations of using SSD disks. They wear down faster than regular enterprise disks, and that they degrade in performance over time without TRIM support in the operating system.
Windows Server 2008 R2 supports TRIM, but it doesn't work on logical devices (raid arrays).
I recommend you to rather look at expanding your spindle count (more disks), and if you are on RAID5 - move to RAID10 for VM storage.
You also mention that one of the servers is both a AD controller and a SQL database server at the same time. This is a highly unsupported configuration - the only case where it's supported is on a Windows Small Business server.