When a credential provider fails to load in VS, don't break NuGet

[joelverhagen]

Instead have a good error message. We should also write to the event log

[yishaigalatzer]

CC @pspill