There was another post regarding enabling hot-plug functionality on the SATA port that solved the problem. That may help if your BIOS settings have than setting and you have yet to try it.
Edit: I completely forgot something. In Device Manager is the drive shown with a yellow exclamation mark? If not open Disk Management. Look to see if the drive has a letter assigned to it. If not assign a letter. If there is a yellow exclamation mark next to the drive right click and select Update Driver. Hopefully it will update the driver and assign the drive a letter.
I looked in bios, and wasn't in raid setup (didn't think i was) and i found the hotplug functionality, mine was set to disabled and i couldn't enable it. that sent me searching on how to enable it and i came across a thread that mentioned any drive that is connected via molex, doesn't support hotplugging, well this drive has a "mini sata" connector on the back and the cable i purchased to power it, connects via molex. so now im wondering if the unit is getting underpowered? honestly that doesn't make much sense to me, but hey, who knows? As of now, I'm unable to enable the hotplug in my bios, unless I'm doing it incorrectly, but i cant find a thread on how to enable it, i would assume since its a newer gui bios, i could just click it? I'm going to look into a different cable. I also noticed that i was plugged into the last sata port, which to my knowledge, doesn't make much of a difference, all my ports are sata 6gbs, so having insufficient speeds doesn't sound right.
https://us.msi.com/Motherboard/Z170I-GAMING-PRO-AC/Specification here's my board
In device manager, there is no yellow exclamation box, however, it is listed under hidden items. I will look into disk manager as well
Thanks for your help