I assume you have an eSATA external connection? How many SATA controllers do you have on your system?
Something you might try is to open device manager and click on the little computer to get Windows to look for devices. It should find and install and external drive, if it was not plugged in during boot.
To make an eSATA drive behave like a USB and be hot swappable, you probably need to set up your SATA controller the drive uses for AHCI. On my system, I have the primary SATA controller set to IDE and the eSATA controller set as AHCI.