Just to add to this. Had this exact issue today and the above solutions still worked. (Just re-saving the service connection with no changes)