Hi all,
Having an issue with my Server 2000 Application log. It keeps filling up
with the following every 4 seconds or so
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17055
Date: 03/09/2006
Time: 13:15:16
User: N/A
Computer: HHSQL01
Description:
18456 :
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 08 00 00 00 48 00 48 00 ....H.H.
0010: 53 00 51 00 4c 00 30 00 S.Q.L.0.
0018: 31 00 00 00 07 00 00 00 1.......
0020: 6d 00 61 00 73 00 74 00 m.a.s.t.
0028: 65 00 72 00 00 00 e.r...
All I can find on the issue is this from EventID
18456: Login failed for user <user name>. - <user name> failed to login to
the SQL Server. I suppose that you use NT authentication, check the applied
policy; the user must be granted the "Access this computer from network"
privilege. If it is SQL account, ensure that SQL server uses mixed mode
authentication.
Any ideas anyone? Its on a SQL 2000 Server
|
Similar Threads
