Find the login history for last one month in sql server RRS feed

  • Question

  • with out turn on the profiler, is it possible get the last one month (or) one week login history...???

    Thursday, July 25, 2013 10:17 AM


All replies

  • You can refer EVENT VIEWER if you have enabled login auditing in sql server.


    Thursday, July 25, 2013 10:20 AM
  • Hello Ravi,

    By default the SQL Server don't log the logins; you can find only failed logins in the SQL Server Error Log. You can config, that all login are log to error log, but it's not that easy to analyse the (text-) error log; see Configure Login Auditing (SQL Server Management Studio)

    Or you could implement a logon trigger to log all successful logins to a user defined table; see MSDN Logon Trigger

    Olaf Helper

    Blog Xing

    • Edited by Olaf HelperMVP Thursday, July 25, 2013 10:23 AM Link added
    • Marked as answer by RaviDuggineni Thursday, July 25, 2013 10:35 AM
    Thursday, July 25, 2013 10:21 AM
  • There is no such option for capturing successful logins by default.

    You may consider Logon trigger for the same.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Thursday, July 25, 2013 10:23 AM