Having installed Windows 7 onto the box that I am using as a Media Center everything seems to work fine, except Media Center treats the dual tuner card as if it only has one tuner. It recognises the dual tuners during set-up, but when you try and use the two tuners in practice it says there is a conflict and shows the two tuners are already both in use. Argh!
A little bit of investigation shows that this is a common issue. Try here for a great summary thread that lists the affected cards (which includes the Hauppauge dual tuner that I am using) on The Green Button.