Login information

Hi,

Can we retrieve the Login Failed and succedded for SQL Server?

I want to know the login failed and succedded information of SQL Server.

Can we retrieve the same?

Let me know ASAP.

Thanks and Regards,
Pramod

open enterprise manager, right click on your server, on the security tab select the Audit level option that you want out of none, failure, success or all.

FatherJack

The loggin information is written to error log. You can use xp_readerrorlog to read the content in a table format, then search for success or failed string.

Thanks for the help,
Since the current active log file is locked by SQL Server, does xp_readerrorlog file returns the current values?

Thanks and Regards,
Pramod.

Yes, and you can open sql server log file with any text editor.

Yes xp_readerrorlog reads current file, if you want to read older log you can pass the errorlog number

xp_readerrorlog 1