Login Failure - Windows Script Host

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  February 21, 2012 at 7:48 am

  #251931

  Hi

  I have an issue where I get a failed login every 5 minutes

  Login failed for user 'domain\servername$'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

  Profiling has shown it to be a Windows Script Host coming from a particular server. However how do I track down what it actually causing it?

  Thanks in advance

• derek.colley

  SSCrazy Eights

  Points: 8040

  More actions

  February 21, 2012 at 8:04 am

  #1449718

  I use WSH for VB scripting, i.e. I will invoke SQLCMD from a batch file, then feed it an input SQL file, then do something interesting to the output using vbscript. Alternatively you can use protocols like ADODB from within VBScript, invoked by WSH.

  For this reason I'd start looking at the error log on the originating server, search for scheduled tasks on this server, search for .vbs, .bat files on this server, and do your detective work there. You should be able to narrow down the list of suspects.

  If it's a SQL Server Agent job running, check the Job History and drill down (in SSAS) to the job logs, you might get a more comprehensive summary. It's likely though your answer will be in the Windows application log on the originating server.

  ---

  Note to developers:
  CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
  So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

  Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
  My blog: http://uksqldba.blogspot.com
  Visit http://www.DerekColley.co.uk to find out more about me.