I had "exactly" this issue!
If unblocking your drain tubes doesn't help, you may need to look at your rubber seals. That is what ended up causing my leaks! Not my sunroof, I tried everything before I replaced the rear door weather seals and the channel rubber.
Good luck with it mate
