Heineken has confirmed it will end the tie-up between its John Smith's bitter brand and the Grand National horse racing meeting in the UK.