Nottingham Forest have confirmed Alex McLeish as their new manager after sacking Sean O'Driscoll earlier this week.