|Well the drive is spinning up which means the motor works but that doesn't mean it's able to read disks.|
If the bios doesn't see it, device manager won't either.
It sounds like you've verified it's connected good. The only other thing would be a bios setting. You might check the manual on that. You should be able to download the manual from the support page for your model. I don't have time to look it up now.
Otherwise, assuming it is bad, you'll need to look for a replacement or maybe an external drive.