open the sunroof and then stick your head out of it and you will see various mechanical slidy things around the edge of the roof. Grease these up and open and close the roof a few times even if you have to help it, and each time you open it grease up the dry slidy bits and if you can get access to the wires grease those to.

Us scottish are good at fixing sunroofs as they get so little use