I have a 1998 C230 and I don't have my Haynes manual with me.
However I had the same thing happen to me except without the rattle and my keyless entry wasn't effected (though for the life of my car the air temp sensor mounted up there vibrated a low annoying hum).
For a few days or a week my ceiling console wouldn't work. I don't recall exactly but I may have replaced all the bulbs in the console. Suddenly everything started working again and haven't had an issue with it since (few years).

Does your rear view mirror dimmer work? and can you open and close door windows with the remote?

The console lights and sunroof do have in common automated activation through the keyless entry