Thought I would add to this existing thread. My granddaughter recently bought a 2009 Jeep Patriot Rocky Mountain Edition with a leaking sunroof.
The dealer (used car lot) tried all kinds of hatchet jobs to fix it and finally gave up. They offered to give us our deposit back or knock $1000 off as they stated it needed a new sunroof. I had already researched the issue and was fairly confident I could fix it myself. They did soak the interior 'testing' all of their non-fixes so we had to pull out the entire interior anyway for steam cleaning and baking soda dusting. We vacuumed gallons of water out. Idiots.
Sorry I did not take pics except for the grommet and a bare interior but I fixed the leak for good for about $12.00 and a lot of labor.
What I found upon pulling the drain tubes loose from the sunroof was that both front tubes were clogged. I was going to install the drain tubes and grommets called for in the TSB but there was a delay in getting the parts so I went to the hardware store and bought clear PVC tubing, 3/8" i.d. to make my own drain tubes.
When I removed the old grommets from the firewall they were indeed the 'bad' kind having a 90 degree bend. They also had 'fingers' or whatever inside (to catch debris????, BRILLIANT) further reducing the drain area to a pinhole. They were clogged with seeds and just mush consisting of who knows what. I took a razor knife and cut the 90 off, then I reamed the hole out to fit my entire 3/8" tubing completely through the grommet so there is now a 3/8" diameter hole to drain the water. I turned the grommet around backwards so it could be inserted from the engine side of the firewall first as there is absolutely NO WAY to get the grommets pushed in from the inside. I could not peel back the jute enough to even see the grommet from inside and wasted most of a day trying. I inserted the new tubing from the engine side and was able to grab it and route it properly up to the sunroof. Installed new tubing in the rear although they were easy (and were not clogged).
Ran gallons of water from a garden hose all over the top of the car and it dripped right into the channel as it is supposed to and drained away with ease. I did seal a few rivet holes and other penetrations outside of the main drain channel just as added insurance.
We thoroughly cleaned every square inch of bare interior and upholstery/carpeting and it looks and smells great, and we got a great price.
We also have a 2009 Patriot (without a sunroof) so now there are 2 in our driveway