The creation of the linked server fails for some reason.

You didn't post the actual error message, so it's nearly impossible to give sensible advice.