Open the sunroof all the way and check the 2 drain holes visible in the front corners. Make sure there'* no debris. Remove your A-pillar trim and make sure the hoses aren't plugged (pull them off, and run a piece of wire through the drain holes, then down the tubes).
Do you have wind noise? The sunroof seal (weatherstripping) replacement procedure is in Techinfo. Nevertheless, even if water gets past this seal, it should still drain out the pillars without getting the car wet if the drains aren't plugged.
Moving this to 92-99.