Failure Audit - Event ID: 18456

Hi I'm using SQL Server 2005 and ,
I keep getting the following message in the Event Viewer:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 1/21/2008
Time: 8:32:00 AM
User: domain\sqladmin
Computer: TCLG-MOSS-DB
Description:
Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
Can someone please shed some light on this......
Thanks,
ShelleyYou have audit login set either to "Failed logins only" or "Both failed and
successful logins". You can change the setting vai SQL Server 2005 Management
Studio. Right click on the server instance and pick Properties. Select
Security, and you'll see the audit options. You need to restart the SQL
instance for the audit level cahnge to take effect.
Linchi
"Shelley" wrote:
> Hi I'm using SQL Server 2005 and ,
> I keep getting the following message in the Event Viewer:
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 18456
> Date: 1/21/2008
> Time: 8:32:00 AM
> User: domain\sqladmin
> Computer: TCLG-MOSS-DB
> Description:
> Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
> Can someone please shed some light on this......
> Thanks,
> Shelley
>
>|||Hi, thanks for the reply.
This error basically happens with unsuccessful attempts to log on to the
server?
Would like to know the cause of the error.....
Thanks,
Shelley
"Linchi Shea" wrote:
> You have audit login set either to "Failed logins only" or "Both failed and
> successful logins". You can change the setting vai SQL Server 2005 Management
> Studio. Right click on the server instance and pick Properties. Select
> Security, and you'll see the audit options. You need to restart the SQL
> instance for the audit level cahnge to take effect.
> Linchi
> "Shelley" wrote:
> > Hi I'm using SQL Server 2005 and ,
> > I keep getting the following message in the Event Viewer:
> >
> > Event Type: Failure Audit
> > Event Source: MSSQLSERVER
> > Event Category: (4)
> > Event ID: 18456
> > Date: 1/21/2008
> > Time: 8:32:00 AM
> > User: domain\sqladmin
> > Computer: TCLG-MOSS-DB
> > Description:
> > Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
> >
> > Can someone please shed some light on this......
> >
> > Thanks,
> > Shelley
> >
> >
> >|||Correct.
Linchi
"Shelley" wrote:
> Hi, thanks for the reply.
> This error basically happens with unsuccessful attempts to log on to the
> server?
> Would like to know the cause of the error.....
> Thanks,
> Shelley
> "Linchi Shea" wrote:
> > You have audit login set either to "Failed logins only" or "Both failed and
> > successful logins". You can change the setting vai SQL Server 2005 Management
> > Studio. Right click on the server instance and pick Properties. Select
> > Security, and you'll see the audit options. You need to restart the SQL
> > instance for the audit level cahnge to take effect.
> >
> > Linchi
> >
> > "Shelley" wrote:
> >
> > > Hi I'm using SQL Server 2005 and ,
> > > I keep getting the following message in the Event Viewer:
> > >
> > > Event Type: Failure Audit
> > > Event Source: MSSQLSERVER
> > > Event Category: (4)
> > > Event ID: 18456
> > > Date: 1/21/2008
> > > Time: 8:32:00 AM
> > > User: domain\sqladmin
> > > Computer: TCLG-MOSS-DB
> > > Description:
> > > Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
> > >
> > > Can someone please shed some light on this......
> > >
> > > Thanks,
> > > Shelley
> > >
> > >
> > >