I had the same problem in my 2011 SRX. Common problem is the sunroof drain - the hose is too short and it vibrates out. Your dealer will know about it - insist they pay for it even if out of warranty.
If you are handy, this is easy to check (but hard to fix) - pop off the interior panel on the front A-pillar (the A-Pillar is the post between the windshield and the door). You can pry it off with your hands, no tools needed. After it is off you will see some wires and a white plastic tube about 1/2" diameter. That white tube runs from the sunroof drain channel in the roof (one of several) down the A-pillar into the firewall just below the dashboard at the very bottom corner of the windshield. It has a black rubber fitting that fits into a hole in the firewall and that is what pops out. So when it rains, the water runs down the top of the glove box, drips on the carpet in the passenger footwell. This is a big issue as it runs right over the electronics and the ECM - this will cause BIG problems if not fixed (aside from the inevitable damp stink).
If you use a flashlight and peer from the outside of the car in the corner of the windshield on top of the dash you can see how it connects (you must remove the A pillar cover first). It is extremely difficult (impossible) to use your hands and pop the fitting back into the firewall. You can either disassemble the dash or like I did make a long bent special tool to push the black boot/tube back in. Tip - use some dish soap as a lubricant.
To test the if this is your problem just tape the entire sunroof gap from glass to roof all around to seal it. Hose the car and if the problem is gone, you found your problem.
THIS WAS VERY HELPFUL. I HAD BEEN HAVING A LEAK IN MY 2010 SRX FOR ABOUT 3 WEEKS AND HAD NO IDEA WHERE THE WATER WAS COMING FROM UNTIL I READ THIS. SURE ENOUGH, IT WAS THE DRAIN HOSE, IT CAME LOOSE AT THE TOP. IT TOOK A LITTLE WHILE TO FIGURE OUT, BUT I WAS ABLE TO CONNECT THE HOSE BACK AND YES IT IS A VERY VERY TIGHT SPACE. BUT THANKS TO YOUR HELP, I FIXED IT; AND I'M A WOMAN. LOL.