Put it in another IDE port (swap with hard drives), and/or switch IDE cables. If that doesn't work, then put another drive in its place. If the other drive works, but the DVD-ROM doesn't, then you should most likely replace the DVD-ROM drive.

Also, try updating firmware and drivers. I don't know if this is the problem, but it could be SP2 as well.