For non-panorama sunroofs, I know there is a drain in each a-pillar. If you open the sunroof, pour water slowly in each front corner, you should see water come out under the car from the drain tubes. If not, the rubber tubes are likely kinked or out of the metal drain tubes.

__________________
Daily Drivers:
- 2008 535i, 320,000km
- 2004 X5 4.4, 01/2004 production, 420,000km
- 1997 328i, 350,000km

Track:
- 1996 328i, track/race car, ~300,000km

Winter:
- 2013 Ski-Doo MXZ X 800 E-TEC, trail can
- 2007 Ski-Doo MXZ Blizzard 800 HO
- 2001 Ski-Doo MXZ 600 w/800 engine, exhaust
- 1978 Ski-Doo Olympique 340 (vintage race sled)
- 1977 Ski-Doo Olympique 340E