Post reply

Logging logins

  • December 20, 2001 at 8:20 am

    #158135

    I am new to this site and to working with mssql. My question is this: we are running sql server 7.0 on windows NT. We are having a problem with logins being recorded in the log and eventviewer every few seconds while users are connected. The database as far as I can tell is set only to audit failures. Any ideas on what might be causing this?

  • December 20, 2001 at 8:22 am

    #421333

    If the audit was changed to 'audit failures only', but not stopped and restarted I think it would carry on logging the lot.

    Steven

  • December 20, 2001 at 10:02 am

    #421336

    I think Steve is right. Try a restart.

    Steve Jones

    steve@dkranch.net

  • December 20, 2001 at 2:00 pm

    #421344

    Thanks. I'll give that a try and see what happens.

  • December 21, 2001 at 9:44 am

    #421367

    Let us know if that helps. Also, what Service pack is this? (SQL and NT)

    Steve Jones

    steve@dkranch.net

Viewing 5 posts - 1 through 4 (of 4 total)

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