in place your sunroof should not leak. They are meant mainly to suppress wind noise.

You probably have one or more clogged drains. Use heavy weight monofilament or solid core electrical wire to clean them out. On my W123 there is one in each corner. I believe our sunroofs are similar.