Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Event Viewer Log Over Flowing

Author  Topic 

orgbrat
Starting Member

1 Post

Posted - 2004-07-31 : 23:18:06
I have just installed SQL Server 2005 Beta 2 and the machine that I installed it on now has the Windows Application Event Viewer log is over flowing with Event# 18453 "Success Audit", Source is MSSQLSERVER, Category is "Logon". It is creating this Event Viewer entry every 7 seconds and I can not determine how to stop the entry. is there someone that has had this problem or can tell me how to handle it. Thanks....

Steve Graddy MCP, MCAD.Net

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 2004-08-01 : 00:29:18
Don't have Yukon handy but in SQL2k you change this by going into Server Properties, Security and changing the auditing.

-Euan
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-01 : 15:40:37
If you go to the workbench, right-click on the server in the Object Explorer and go to properties. Click on Security and change the Login Auditing to only audit for failures.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -