Ah think i've solved it.
After the migration I renamed the Server to the same name as the previous one.
However the SQL connection was still referring to the previous name given to thi new box.
Simply changed that to the current name, and bob is your mothers brother.