I connected another External Sony CD Drive PCGA-CD51/A and the same thing.
Also the same with my Maxtor External Hard-drive.
All 3 appear with ! in Device manager.
I have tried uninstalling and reinstalling to no avail. The CD-Drive was working fine. I hadn't used it in a while as I turn off to save power on my laptop (using 'Vaio Power management' ) and it surprised me to find it in this state when switched to on.
Thanks in advance for any help,