Sunroof drain tubes either come off the actual sunroof, or the pipes blocked and it leaks where the tube joins the sunroof.
Remove the trims and have a look around the headlining.
Are the drain tubes only at the front of the sunroof or the back as well? I've clean mine out and poored water down them no problems and it seemed to work for a few weeks but I've got it leaking again to the right of the drivers sun visor.
Appreciate help with this as it's doing my nut in down because I've done a few things and just can't locate where is letting the water in.
Right theres 2 drains from the sunroof, both at the front, one on each side, did you push the pipes back on all the way properly, and made sure they won't slip off, maybe a small cable tie around them both. Where they disconnected or blocked when you first had a look at them? Do you park under a dirty tree, or clog your drains with wax or polish, just ideas.
To the right of the drivers sunvisor, whats your actual door seal like aswell, I'd check your drains again, and clean them again first, could even be a leaky sunroof, bad old or perished seals perhaps.