Hard Drive not being detected

I have a computer using Windows 7 OS, the OS is on an SD drive and I have an HD drive also installed for extra space. The other day when starting up my computer I got an error message that read: ntldr is missing pres ctrl+alt+del to restart. After doing some google searches and trouble shooting I noticed I was getting the following message on a loading screen:

controller bus #00, device #1F, function #02: 06 ports, 02 devices
port -00: Hard Disk, ST1000DM003
port-01: no device detected

At this point I disconnected my HD drive and see this message:

controller bus #00, device #1F, function #02: 06 ports, 02 devices
port -00: no device detected
port-01: no device detected

I understand that it is not finding my SD drive and I tried switching the cables with ones I know work and it still does not find it, so it's not bad cables and must be a problem with my SD drive. Is there anyway to fix this problem or is my SD drive just ****ed?

Thanks in advance.