u/Automatic-Pool-9245

I have a 2020 rogue and recently, I noticed water stains inside. From research I concluded that the drain tubes down the pillars were clogged. I followed some instructions and discoverd that they were not clogged. Next step was taking the roof rails off to seal holes around connecting pieces. That’s didn’t fix anything. I’m now seeing that water is dripping from a middle piece of the sunroof where the two glasses meet and where the front glass tilts open.

Does anyone have any ideas if this could be the only cause for the water and how I can go about fixing it myself.