SQL Server Failure Audit. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server Failure Audit.

Author

Topic

petek
Posting Yak Master

192 Posts

Posted - 2010-10-29 : 05:01:00

Hi All,

Firstly thanks for looking at this post.....i have a problem with SQL Security. i have two BES servers talking to one DB on a Named instance of SQL 2005.

Both Bes servers are identical and use one service account to communicate to the DB.

For one of the BES servers i get the following error:

Event Type: Failure Audit
Event Source: MSSQL$INSTANCE
Event Category: (4)
Event ID: 18456
Date: 29/10/2010
Time: 09:49:52
User: USERNAME
Computer: IFS-WB-SQL-12
Description:
Login failed for user 'USERNAME'. [CLIENT: 10.6.11.25]

Date 29/10/2010 09:55:51
Log SQL Server (Current - 29/10/2010 09:55:00)

Source Logon

Message
Error: 18456, Severity: 14, State: 16.

The user has access to the DB as the other BES Server uses the same account.

Any ideas

Kind Regards

Pete.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources