Plug ins?...aren't you thinking of software?...
Basically with hardware you can setup either a master or a slave for a device. So a master Hard drive and a Slave hard drive (same for DVD/CD devices).
So this means that that cable from the CD/DVD drive will work fine.
The main way of setting this is by using the jumpers. These will be on the back of the drive.
For example i saw in another post you had a samsung hard drive on one PC:
That would be the configuration of the pins. Now you would have the PCs primary drive (the ones that's already installed) as the MASTER and you would then put the jumper over pins 5-6 to make this hard drive the salve (if it was a samsung hard drive). This would then make sure that the operating system was loaded from the master hard drive and not the slave.
Also this can be done in the BIOS but that's fairly general so try the jumpers. Set the jumpers then plug in the IDE/SATA cable and the power cable and boot up. It will take slightly longer to load however.
Then the hard drive should be picked up by Windows and you will be able to see all and copy all of the data.
Then because of the CMOS reset not working I believe you have a bad power supply. If you can you should test this with a new one or try the possibly broken power supply in another PC and see if it works.
Also you could try a power supply tester, which you can get from most PC shops. However before doing that try and do what Kimsland said earlier and listen to the hard drive as you start the PC. If it sounds as though its spinning up then its something wrong with your Graphics card, screen or connection.