Disk drive only mountable when waking from sleep

Do you have floppy drive it sounds like you need to run fdisk from a boot disk and set the partition as active,also check to see if the drive jumper is set to slave.

Thanks for the comment.  No floppy drive so I put the PC to sleep and looked at the disk.  No jumpers were on the pins.  When it resumed from sleeping I ran Computer Management, Disk Management snap-in and see that the disk is shown as "Simple Basic NTFS Healthy (Active, Primary Partition)".  Good thought though joinaunion.

I,m not sure why it is seen as a primary partition when its a second drive.Can you check the sata cable your primary(os)drive should be on sata 1 then the other drive should be drive2 and so on.In your bios it should be seen as a slave drive is it?Can you please tell us your motherboard model this way we can look up the proper order.

Oh one other thing just to be sure.right click my computer then click properties then in bottom left click performance then under task click adjust power settings then under the one that is selected click change plan settings then click change advanced power settings.Goto where it says Hard Disk click the plus sign then click setting and change it to never then click apply and exit see if it still does it.

The system disk in in SATA1, the problem disk in SATA2 and the other 4 SATA ports are empty.  The mobo is an Abit IP35 Pro as described at
http://www.abit.com.tw/page/uk/motherboard/motherboard_detail.php?DEFTITLE=Y&fMTYPE=LGA775&pMODEL_NAME=IP35%20Pro

cpuz.htm.txt
ip35-pro.zip

Have you installed the JMicron sata driver from your motherboard cd.Put the motherboard cd in then click the drivers tab then click JMicron sata driver then follow prompts to finish.If this does'nt work there is one more option but i,ll wait until you try this first.

I put the CD in and it displayed a message about searching for devices.  After a short time Windows Explorer came up with the missing drive open.  I then installed the JMicron driver and restarted the PC.  Still the drive does not get mounted.  I was left with a program named JMB36X Raid configurer, but when run it just gives a message: "JMB36X Raid Device is not found!"

Ok then in your bios you need to set the drives to achi mode not ide then set your bios to boot from cdrom then put in your windows cd when it gets to the setup choose repair option then when your prompted press f6 I belive for third party drivers you may be prompted for your mobo cd once this is done reboot then tell us what happens.

Just to let you know that I am not ignoring this.  I will take an image backup and run a Vista repair when I am able then revert here.
Thanks.

ok :)

I set the BIOS to AHCI mode for the disks and booted into the installation DVD for Vista64.  I took the repair option and then clicked the 'load drivers' button.  I slipped the mobo driver CD in and then chose
drivers\sataraid\intel\vista64\iaahci but no drivers could be found to match the hardware.  I then repeated the steps with the directories drivers\sataraid\intel\vista64\iastor and drivers\sataraid\jmicron\vista64\jraid_f_w but both times I just got back to the earlier screen with no message or apparent action.

Now at the earlier screen and wondering which option to take from
Startup Repair
System Restore
Windows Complete PC Restore
Windows Memory Diagnostic
Command Prompt

I tried the first option but was told that "startup repair could not detect a problem".
If this were XP then a repair installation would be the action of choice, but this is Vista.

So being unable to boot with AHCI enabled, I reset it to IDE and booted.  Of course, the same problem exists.

Incidentally, the hidden disk made a good place for the image backup file (65GB).  So the disk is seen if I boot off an Acronis CD.

Ok in your bios leave it achi then goto intergrated peripherals then onchip ide device then sata mode then select raid.Then when you reboot boot from your windows cd choose repair option  when your prompted for third party drivers hit f6 or whatever it is then you will need your mobo disk and you want drivers\sataraid\intel\vista64 .If that directory wont work try drivers\sataraid\jmicron\vista64
Of course this is located on your mobo cd.
I,m not sure how much memory you have but if its 4gigs and above you may have to take some out before you try this 3 gigs or less then reinstall after this works.

Joinaunion, I appreciate your time and comments, but am wondering if we are shooting in the dark here.  I am not sure if there is a path that is being followed, but setting a JBOD system to RAID seems unlikely to be the fix I am after.  I have 4GB RAM and don't see why reducing that could be of help in enabling me to see a disk drive.  I am assuming you are aware that repair installs of Windows Vista are only possible if booting off the HDD, and that is only possible if the BIOS settings match the HAL that is on the disk.

Read my solution here. https://www.experts-exchange.com/questions/23524317/How-do-I-configure-SATA-hard-drives-to-AHCI-on-Asus-P5E-VM-HDMI.html?cid=236