Limit information the error log

[mikej28621]

My error log is filling up with info like:
2003-10-16 12:48:13.40 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:48:13.56 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:48:13.62 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:48:13.65 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:49:20.26 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:49:21.28 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:49:44.99 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:49:46.03 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.63 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.68 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.71 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.76 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.84 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.88 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.93 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:02.99 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:03.04 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:03.07 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:03.09 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:28.62 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:28.66 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:28.74 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:28.79 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:28.82 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:28.85 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:50:35.84 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:53:14.89 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.
2003-10-16 12:53:15.89 logon Login succeeded for user 'MYDOMAIN\Me'. Connection: Trusted.

Since these aren't errors is there a way to not log these. I am getting 2-5MB per day.

Thanks in advance

 

[Glyndwr]

mike

In the EM goto to the node for this SQL Server in question

right-click -> properties

goto security tab and you will notice that the audit level has been set to ALL or Success change to None or failure to stop logging successful connetcions.

Though before you do this check your corporate security policy

 

[mikej28621]

I tried Glyndwr's advice and I am still getting the messages. I just noticed that I am also getting the exact same messages in the Application log of the Event Viewer.

Thanks

MJ

 

[JamesLean]

Once you've changed the audit option to none/failure then you need to restart the SQL server. Did you do this?

--James