finally sorted the issue, in the end all i had to do was to remove the user from the applicationimpersonation role and re-add, wait a few hours and then tried to set the connection up which went through with no errors