Definitely the seal on the roof. Easy test - is it still noisy when you have the panel underneath the pan roof fully deployed or only when its retracted and you only the have the glass between you and the heavens?
What they said - replace the seal. About 25 quid from the dealer. Makes a world of difference. The old one was noticeably weathered/cracked and not very flexible.