The Work:
The secret weapon is 5 minute epoxy and a 5/16" brake line, about 1-1/2" long that fits into both the hose and baffle.
Before you start, make sure that the brake line fits into the baffle and the hose before you start.
Epoxy the tube in the drain hose and let it set for an hour. After, do another epoxy around the new joint. Let that sit for an hour.
Afterwards, smear epoxy around the other end of the tube and place that in the baffle. Repeat again, and there you go.
Since epoxy sticks to everything, place a sheet of saran or cling wrap underneath.

Simple Access:
Remove the trim around the sunroof
Unscrew half of the map holder compartment, sun visor and Jesus handle above the window
A bit of arm bending for access. The liner is flexible, and a small LED flashlight will help.

DONE!

 

I had to do something similar. I was finishing up some repair (I forget which) and was putting the overhead map pockets back in place. I put a screw right through the center of the drain hose. I cut the hose and installed a Male to Male b@rbed hose coupler with a bunch of silicone around it. Hasn't given me any trouble since.