• I've have faced the similar issue which I have found is caused by SQL service account which was locked. My SQL Service account was running under a domain account and it got locked due to certain reason and we're not informed. While querying using xp_loginfo we're getting this error. After diagnosis we came to know about account locking. Post unlocking the service account on domain issue got resolved.

    Regards
    Rakesh