December 19, 2005 at 1:21 pm
just installed sql2ksp4 on a production server yesterday.
ever since the restart the sql server log is just flooded with login succeeded messages.
when i run a profiler trace to audit login/ logout every command issued is seemingly resulting in a log out event.
all the applications seem to be fine, but it is just flooding my log and the one that fails from a service is just hammering my pager which would normally only happen whenever the server restarts.
any thoughts on what could cause this behavior?
December 19, 2005 at 1:27 pm
Check to see if your database properties got changed to AUTOCLOSE (Enterprise Manager, right click on the database, select Properties, go to the Options tab).
-SQLBill
December 19, 2005 at 3:40 pm
went thruough all of them and none were set to autoclose
didnt think to look for it right away because if it was closing i would expect to see starting database appear in the log as well.
December 20, 2005 at 2:30 am
In Enterprise Manager check Server Properties | Security Level. Perhaps your Audit Level is now 'All'?
That shouldn't change with a SP4 apply though. We've done dozens of SP4 applies and our regular Audit level setting of 'Failure' has not been affected.
December 20, 2005 at 7:38 am
When you're logged on through Enterprise Manager or Query Analyzer, do you see the same behavior with respect to your connection in SQL Profiler?
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply