dougdavis22
Hot Shot
Hot Shot

vCenter 4 & SQL with Windows Authentication - Event Log Errors

Jump to solution

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.

0 Kudos
1 Solution

Accepted Solutions
dcsteam
Contributor
Contributor

OK - managed to resolve my own problem by resolving another........

Noticed that the Performance Overview charts in vCenter were throwing an error - restarted the vCenter Management Webservices service on the vCenter server, that resolved the Perf Charts error and the SQL event logs stopped being generated too.

Doug.

View solution in original post

0 Kudos
1 Reply
dcsteam
Contributor
Contributor

OK - managed to resolve my own problem by resolving another........

Noticed that the Performance Overview charts in vCenter were throwing an error - restarted the vCenter Management Webservices service on the vCenter server, that resolved the Perf Charts error and the SQL event logs stopped being generated too.

Doug.

0 Kudos