Mine did the same, turns out it wasnt the sunroof, if you remove the trim surrounding the speaker you will most likely see a nasty bit of corrosion in the corner were the rear quarter meets the roof, its leaking in through the gutter.
Pain in the arse to stop, just need to wait for a dry day...