I've yet to find this to be a SP2 issue. But there is plenty of urban lore that it is.
Bob
Just purchased Western Digital Essential Edition 500 GB My Book 2.0 USB external drive. Windows sees the hardware, but refuses to recognize any drives defined on it. According to the documentation that came with the drive, it should have installed some startup software when first connected. That didn't happen.
The drive is correctly identified under Disk Drives in the Windows Device Manager. However, Disk Management fails to see it. I see two other internal drives there, along with my CD and DVD drives. I considered the number of drives might be an issue and disconnected one of the hard drives. The WD drive still didn't show up. I considered that the drive might be assigned a particular letter, but reassigning existing drives to where "E" and "F" were open, did not help.
I am running Windows XP SP2 on a Compaq Presario. My USB ports are 2.0. All drivers are latest available. I have seen conflicting information about whether or not Service Pack 2 might be the issue. Going back to SP1 isn't really an option.
I really want to use this drive, but I am fast approaching the 30-day return policy limit. Any suggestions would be greatly appreciated.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic