Monday, February 20, 2012

Logging of logon success filling up logs.

How can I turn off the logging of succesfull user logon to the databases?
This is filling up both the SQL logs and the Application event logs.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17055
Date: 12/07/2003
Time: 2:14:14 PM
User: N/A
Computer: ***
Description:
18454 :
Login succeeded for user '*********'. Connection: Non-Trusted.
--
John Tolmachoff
MCSE, CSSA
Owner Consultant/Engineer
eServices For YouIn enterprise manager server properties ecurity set the audit level to
not log successful logons.
Nigel Rivett (SQL Server MVP)
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment