There's a drain in each corner of the sunroof tray. Open the roof all the way and you'll see the holes.
The front ones run down the A pillars. A piece of trimmer line fed down gently works better than compressed air, since air can blow the tube off at the bottom and make it worse.