I've been working on a clean install of SQL 2005 & vCenter 4, and have opted to follow the Best Practice guidelines and have setup Windows Authentication for the DSN and the vCenter services. After a few niggles I've got everything working fine, however there are lots of Application events being generated on the SQL server as follows:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/20/2009
Time: 2:17:48 PM
User: NT AUTHORITY\ANONYMOUS LOGON
Computer: SQL03
Description:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00
0008: 0d 00 00 00 44 00 43 00
0010: 53 00 56 00 50 00 57 00
0018: 4d 00 53 00 51 00 4c 00
0020: 30 00 33 00 00 00 07 00
0028: 00 00 6d 00 61 00 73 00 ..m.a.s.
0030: 74 00 65 00 72 00 00 00 t.e.r...
It doesn't seem to be causing any actual problems, but I don't want my Application event logs filling up with these and ideally I want to get to the bottom of it so I know nothings actually wrong before I start getting it ready for production.
I know this used to be an error that was received (similar anyway) when you didn't have your SQL server set to mixed authentication & were trying to use a SQL account for your DSN, but not sure what it's up to now.
Any help appreciated.
Doug.
