syspolicy_purge_history generates failed logins

Posted by jbrown414 on Server Fault See other posts from Server Fault or by jbrown414
Published on 2010-12-09T20:39:20Z Indexed on 2011/01/31 7:27 UTC
Read the original article Hit count: 1202

Filed under:
|

I have a development server with 3 instances: Default, A and B. It is a physical server, non clustered. Whenever the syspolicy_purge_history job runs at 2 am, I get failed login alerts. Looking at the job steps, all are successfully completed. It appears that some point during the step "Erase Phantom System Health Records" is when the failed logins occur.

syspolicy_purge_history on instance B works OK.

syspolicy_purge_history on the Default instance seems to want to connect to instance B, resulting in:

Error: 18456, Severity: 14, State: 11. Login failed for user 
'Machinename\sqlsvc-B'. Reason: Token-based server access validation 
failed with an infrastructure error. Check for previous errors. 
[CLIENT: <local machine>] . 

No errors are reported by Powershell.

syspolicy_purge_history on the A instance seems to want to connect to the Default instance resulting in

Error: 18456, Severity: 14, State: 11. Login failed for user 
'Machinename\sqlsvc-Default'. Reason: Token-based server access 
validation failed with an infrastructure error. Check for previous 
errors. [CLIENT: <local machine>] . 

Then it tries to connect to the B instance, resulting in

Error: 18456, Severity: 14, State: 11. Login failed for user 
'Machinename\sqlsvc-B'. Reason: Token-based server access validation 
failed with an infrastructure error. Check for previous errors. 
[CLIENT: <local machine>] . 

No errors are reported by Powershell.

I tried the steps posted here hoping they would fix it. http://support.microsoft.com/kb/955726 But again, this is not a virtual server nor is it in a cluster. Do you have any suggestions? Thanks.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008