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: 1233
sql-server
|sql-server-2008
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