You can remove the glass to get to the drains, if it's a pressing problem that has to be solved right now. The simplest reason for sunroof failure is stuck cables. In order to fix this, you have to remove the entire assembly, glass and tray. The complete instructions are in the FSM. It isn't hard, it just takes a little time to remove.
Once you have removed the assembly, the cables can be cleaned and lubricated and the assembly resinstalled. The motor logic controller design will prevent you from bench testing the sliding function, unless you're handy with the circuit logic. This is unfortunate because it would be nice to be able to do, so that you don't have to heave the thing in and out to ensure your repair is complete, but that's the way it is.
If you have a 1993-1994 model, this cannot be done without removing the headliner, which is glued in place on the underside of the body roof panel. The later models' headliner fabric is glued onto a panel which is removable. That panel only need to be dropped in front of the rear doors; it doesn't need to be completely removed.
FWIW, the motor was (ostensibly) designed to be turned manually, if it failed (electrically, that is), allowing you to manually slide the glass back and forth. I've tried this on more than a few sunroofs, and failed every time. I wouldn't advise trying it.