Post reply

Find out whether a user logged on a specific day in the past

  • August 6, 2007 at 9:05 am

    #91219

    Is there a way to find out whether a specific user logged on in the past.  Assume auditing was not turned on.  Does sql server save logon info automatically?

  • August 6, 2007 at 9:09 am

    #724865

    Not that I know of.  AFAIK, unless you had profiler running, there's nothing you can do now... except turn auditing on!

  • August 6, 2007 at 9:23 am

    #724877

    yea.. beat the info out of the user

    No, I think as Ninja said you have to turn on auditing

    Everything you can imagine is real.

  • August 6, 2007 at 9:33 am

    #724882

    Thanks Ninja and bledu for your suggestions!

  • August 22, 2007 at 9:59 am

    #728625

    Wandrag,

    Is this something new to SS2005?

    I know that SS2K can audit into the Windows Application event log either a successful login or a failed login (but not both). And it does not register a logoff.

  • August 23, 2007 at 8:28 am

    #728960

    Actually, in SS2000 there are the audit level options of None, Failure, Success and All.  I use the Failure option myself but I would assume if you choose All that you would get both Failed and Successful Logins.

    Steve

  • August 23, 2007 at 8:53 am

    #728984

    Indeed, All gives you Successes and Failures.

  • November 29, 2007 at 9:50 am

    #755530

    Hey Anne,

    I suggest looking at a third party software like Idera, AppDetective or Lumigent.

    It just depends what your actually looking for.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply