I have just installed The Sims 2 on WinXP SP2. The installation completed fine. When I put the CD in the drive to run the game or click the icon to play, the error "No CD-ROM" with text "Please insert correct CD, click OK and restart application" appears (can't remember exactly sorry - not at home right now).
All other games work no problem.
I've tried the EA website. They have very basic help there, like clean the CD, use other CD drive, disable background tasks. None of those helped.