I would try checking the BIOS settings to make sure you have that configured correctly, and also the jumper settings, if it is a PATA hard drive (IDE 100 OR 133).
If using PATA/IDE 100 or 133:
The drive connected on the end of a cable should have jumper setting set to master, and the one in the middle should be set to slave. Some also allow for "Single" as a separate option if only one drive on one cable.
Make sure the drive you are having problems with is set as the slave, and the good drive set as the master. If that doesn't work, try a different connection on your motherboard or a different cable.
Another option (since it is making some sound) is to get a cheap USB adapter or case ($15 to $30), and try to connect that way.
Then, once you've rescued what you want (if possible), trash the drive if no good, or if you can use Dariks boot and nuke or another formatting program, I'd do that - just in case you have any possible useful data there (passwords, account numbers, etc). That is only if you can get it to work, of course.
