That SATA connector on the backplane is a combo connector (data+power). A normal SATA power to Molex power cable will not attach properly. But if you have the right cable (with a combo connector) it should work.
Obviously you will lose a HDD bay though. Everyone I know who has done this took the extra effort to use the optical bay power so as not to lose drive capacity.
Mind sharing where you got card and cable.