Post reply

Successful logging Auditing

  • August 16, 2012 at 2:44 am

    #265104

    Guys, I am using a SQL Server 2008 R2 (SP1) box, the logging auditing is set to "failed loggins only", but SQL Server is still logging Successful logins also.

    Any Ideas what / what setting might be causing this behaviour.

    Thanks in advance

    ~Satish

  • August 16, 2012 at 2:57 am

    #1526405

    Logon trigger logging to the event log.

    Login auditing changed from "Both failed and successful logins" to "Failed Logins only" without restarting the SQL server.

  • August 16, 2012 at 3:13 am

    #1526413

    Thanks Anthony,

    Worked for me 🙂

Viewing 3 posts - 1 through 3 (of 3 total)

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