I recommend opening a Support ticket to look into resolving
It turns out it was a permissions issue on the new SQL box.
What sort of permission was missing in this case ?
Did you made a checklist of permissions that time for your future reference. If yes, could you please help me with that ?