0

login failed for user 'domain\localMachineName$'. Reason: Could not find a login matching the name provided. [CLIENT: ]

This appeared on my new SQL Server right after I added it to an existing Windows cluster. It occurs exactly every 5 minutes. Seems a local resource is trying to log in but I can't see what it could possibly be related to.

1

This is how the NETWORK SERVICE account from localMachineName presents itself to SQL Server (and file shares, and web sites, etc).

You need to profile "Login Failed" events (or XE Capture or whatever) to identify the program and/or Windows PID

  • Thanks - set up an XEvent session and captured the following: client_app_name SQLServerCEIP – Peter Nov 21 '17 at 10:54
  • 1
    Just disable the service. This is the telemetry (spyware) element of SQL Server. – gbn Nov 21 '17 at 13:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.