The manager guided Sunderland to promotion in 2005, but not before a huge disappointment.