there are drainage holes near the front of the sunroof, which can get clogged with debris. When clogged, these tubes cause a leak INTO the car. They should be blown out from the top, and then see if the leak occurs again when it rains.
If you open the sunroof, climb on the "running board" and look where I mentioned, you'll see the holes on either side.
I'm surprised that noone else has mentioned this as a possible cause of such a leak.