In my experience - and I have used the free hotel numerous times in the last 24 months - it only works if you are booked on MS for both flight. It also works with codeshare flights, i.e. LH flights booked under a MS code.