Sunroof drain pipe

Hi,

My sunroof is leaking due to the drain pipe popping out of the grommet which then pops out of the side of the car behind of the door, I have the glove box out but still cannot get to the pipe to push back in. Anyone know how I get access so to push pipe back in, does the door have to come off, thanks in advance.