Re: Error 18456 Severity 14 State 16
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Sun, 18 Mar 2007 23:11:36 -0600
You can run a trace or Profiler when a login fails and see
what shows up for the application name when auditing the
Login Failures.
It's on the same box as SQL Server so you could also check
what services may be running under the local administrator
account.The security logs may have more information as well
if you track the logins and details for the logins.
-Sue
On Fri, 16 Mar 2007 06:02:16 -0700, Rob
<Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am getting the following error in my Sql logs and in my Application Event
viewer:
03/16/2007 07:56:00,Logon,Unknown,Login failed for user
'CTPC\Administrator'. [CLIENT: <local machine>]
03/16/2007 07:56:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 09 00 00 00 49 00 4e 00 ....I.N.
0010: 54 00 52 00 41 00 4e 00 T.R.A.N.
0018: 45 00 54 00 00 00 07 00 E.T.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...
I have tried figure out what process is trying to hit this database but to
no avail, how should I go about troubleshooting this? It logs this every one
minute and it is on our Portal server.
Thanks,
Rob
.
- Prev by Date: Re: File Ownership failing for Domain Accounts
- Next by Date: Re: File Ownership failing for Domain Accounts
- Previous by thread: File Ownership failing for Domain Accounts
- Next by thread: Re: Security role problem
- Index(es):
Relevant Pages
|
|
