A Report of Failed Logins 1

[JohnBates]

hi experts,

This is 2005. I have enabled auditing of failed logins.

The failures are logged into the SQL Server logs.

I'm interested in how some of you automate the reporting of failed logins - I'm not looking for an Alert - I need to produce a quarterly report for auditors. I do not have any log Reader software....

Thanks for any ideas. John

 

[Jamfool]

There are a few ways to do this (DDL triggers etc), here is a simple way to read the sql log.

DECLARE @errlog TABLE(LogDate datetime null,ProcessInfo nvarchar(4000),[Text] Text)

INSERT @errlog
EXEC sp_readerrorlog --Look up in BOL, you can supply number to get older logs

SELECT * FROM @errlog

 

[JohnBates]

Thanks, Jamfool. sp_readerrorlog is working well.

John