Well after reading all the info i found in the search, i felt armed enough to get to work and hunt out the problem. screwdivers, sockets and crow bar at the ready

. got all the trim out, headliner off, only breaking 2 trim clips and losing one!!
Now i was expecting the water leaks to be perished pipes or bad connection where they meet the suroof tray, but no, the connections are all fine, its the actual drain connector that the pipes clip onto, where they themselves clip onto the sunroof tray. I can see some sort of sealant has ben used on them so guessing its just this that has perished and i need to re do it, anyone else had that or has it always been just the pipes for everyone??
also debating wether or not to spray the interior black now its all off...........