If you're trying to run the game from a writer (as it seems you are), you'll need an atip hiding utility (either alcohol's Ignore media type or CloneCD's hide cdr media will do).
However, I very much doubt that either of your writers is really capable of making an emulation free copy of a sd 2.8 protected cd (I suspect you just got lucky with your partial working copy of BF1942 which is sd 2.6 and a bit easier to copy than Splinter Cell anyway).
Try alcohol with safedisc 2/3 settings (using a cdrw first) remembering to enable Ignore media type before playing.
If that doesn't work, then you'll probably have to settle for an emulation copy. Just use CloneCD with the default Game CD profile. The copy should work so long as CloneCD is installed on the system and hide cdr media is activated.