Disable logging to event logs

• Kelsey Van Der Kley

  Valued Member

  Points: 50

  More actions

  November 2, 2006 at 8:19 am

  #103263

  Hi All,

  I was wondering if there is a way to stop SQL from logging every single connection to the event logs. It's logging every single connection and really clogging up the event log as well as the SQL logs to the point I can't even open them. I don't care about all the successful logins. I was out of the SQL admin loop for awhile and I don't remember it doing this before. How can I stop SQL from doing this?

  SQL 2000 sp3a on Server 2003

  It logs:

  18453 : Login succeeded for user 'DOMAIN\User'. Connection: Trusted.

  Any help is much appreciated.

  Thanks

  Kelsey

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 2, 2006 at 8:30 am

  #669502

  Could you go to the Security tab in the properties of SQL server and set your audit level there?

• Kelsey Van Der Kley

  Valued Member

  Points: 50

  More actions

  November 2, 2006 at 8:33 am

  #669506

  I just realized that the audit level had been to set to All. I overlooked it the first time. I have changed it back to failure.

  Thanks

  Kelsey