If it doesn't appear under Disk Management then there's a Hardware issue likely.
My guess is one of these two:
1) Loose or defective SATA or Power Cable
2) Defective drive.
I think it's possible to detect the drive in the BIOS even if the power cable isn't attached but I'm not sure. I remember having an issue like this and it was a loose SATA cable (data or power).