Assumption #1: the Slave drive actually does work, it has no defects or anything like that.
Assumption #2: you don't want to use the Secondary Master slot instead of the Primary Slave one for the drive (or you can't use it, because the CD-ROM or whatever is occupying it).
1. Power down the machine, take out the slave drive, and make sure that the data cable is placed in the right orientation, that the power cable is plugged in it, and (most especially) that the jumpers are set properly. If you have the jumpers set for Master and yet the drive is meant to be a Slave, there's going to be trouble.
Plug it all back. Power on the machine. Then,
2. whether the drive shows up in Device Manager or not (and assuming you haven't put anything on the Slave drive yet), use Windows to re-partition and re-format the drive. Since you are using Windows XP Pro, make sure that you format the drive using NTFS.
Reboot the machine. The problem should be solved. However, if it still doesn't recognize the drive in Windows Explorer, then
3. Go to Device Manager. Remove the drive from the list, then press F5 or click the "Check for new Plug-and-Play hardware" button on the toolbar. Device Manager will probably show a couple of Taskbar balloons as it finds the new hardware, etc. (You may have to reboot the machine at this point, but not usually.)
Now, go to Windows Explorer. It should be visible now. If it still cannot be seen in Windows Explorer, then either
4a. Press the F5 key to refresh the display,
or
4b. Just type in the drive letter of the Slave drive in the address bar, followed by a colon, and then hit Enter. You may be surprised that it will show up then.
Now, if after all of this, it STILL hasn't shown up in Windows Explorer, you may have to call in the Ghostbusters :)