The problem I found was that the drain tube had come off of the grommet that directed the drain water to the wheel well. The drain tube and grommet are only accessible through a small hole in the frame inside the car. You can't see the grommet, I had to attach the drain tube by feel. It would have been great to have hands the size of a 3 year old kid. I had already removed the passenger seat and had the carpet pulled back, but I also needed to remove glove compartment to access the hole in the frame. FYI, before I really tore into this project I got a quote to replace the drain tube from the local dealer. I was quoted $400 to replace the tube. I wonder what I would have been charged had they found the tube not connected? After I was done I had a new problem. I removed the passenger seat and in doing so disconnected the electrical connections. This caused the passenger side airbag indicator on the dash to illuminate and flash after I reinstalled the seat. After searching the Internet to resolve this issue I found a procedure to reset the indicator and now all is well.
Flashing Blinking Airbag Warning Light Reset Procedure
1. Turn the key from off to on.
2. Watch the airbag light closely. It will stay on for a few secs. and then as soon as it blinks off (the start of the flashing), turn the key off instantly.
3. Count to 5 (1 Mississippi, 2 Mississippi . . . .)
4. Repeat steps 1-3 two more times until you have done the cycle three times.
5. Now turn the key on and watch the light. It will start blinking in a different, slower manner. This is diagnostic mode. You can watch this for a little while, no hurry.
6. Now turn the key off again, Count to 5 like in step 3 again, and turn back on. If the procedure worked, the airbag light will not be flashing.
Edit: My original problem was that the passenger side window and windshield was fogging up. The cause was water inside the car. If you pour water in the sunroof drain tray and it quickly drains and you don't see the water draining under the car, it is draining inside under the carpet. I wish I had taken pictures. When it drains inside the car it will pool under the carpet. In order to dry the carpet you need to remove the passenger seat and the trim around the doors so you can lift the carpet. Disconnect the battery before you do this to avoid a passenger side airbag fault indicator after you reinstall the seat. Under the carpet in the front and rear, are hard styrofoam inserts that support the carpet and provide a flat surface to place your feet. Under the styrofoam are deep wells in the metal floor that can easily store several gallons of water. The drain tube from the sun roof runs down the pillar and and ends up inside the fender by the interior kick panel. I expected that tube to drain directly out of the bottom of the car, but it does not. Inside the fender the tube makes a 90 degree turn and drains horizontally through the fender behind the plastic wheel well liner. The drain tube pushes on the plastic fitting at this point and has no clamp to hold it on. There is no way to install a hose clamp due to the restriction in working space. I would caution anyone attempting to blow air from a compressor at the sunroof drain to clear a suspected clog as this could easily blow the tube off of the fitting causing water to then drain in the car. If this tube is clogged it is very likely that it is a kink in the tube where it connects to the drain fitting in the fender.