EventQuery Task: SQLException: Login Failed for user 'xxxx\xxxxx'

The following error message after the EventQuery task indicates that the Events2HVAC windows service is trying to login to a local or remote Event provider SQL database with the services windows authentication credentials 'NT AUTHORITY\ANONYMOUS LOGON', which are the default windows credentials for the "local service" account in windows XP.

 Error Message:

 

Date = 11/10/2012 12:02:44 PM

Severity = Error

Source = CMDEntry::Execute

Message =

 

*** Command queue entry failed to execute  *** Please take the manual steps necessary resolve the issue on the equipment below:

 

***  Command Information  ***

Event Name: n/a

Scheduled Time: 11/10/2012 12:02:38 PM

Equipment Item: n/a

Object Reference: n/a

Action: Event Query

Trigger: EventQuery

Job: n/a:EventQuery:n/a:11/10/2012 12:02:38 PM:12931482-4057-4475-8f54-e7cbc3e97269

Worker Object: Streamside.Events2HVAC.CMDQueue.EMS.ScheduleActionWorker

ThreadID: 4

******* Begin Error Details  *******

System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

 

The workaround for this message or similar login failure messages during the EventQuery task is to either:

• Change the windows credentials that the Events2HVAC_Service operates under to a windows user that has the appropriate permissions to the Event provider's SQL database
• Change the login to the Event provider's database to a SQL login (recommended).  (See article)