"Login succeeded for user administrator. Connection: trusted. [CLIENT: <local machine>]" every fraction of a second.

Every fraction of a second there is a record added to the ERRORLOG file located at : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG that reads:

 "Login succeeded for user "<%Domain%>\Administrator'. Connection: trusted. [CLIENT: <local machine>]"

I believe this is causing our server to run extremely slow.

Thanks,

Greg
norgrenitAsked:
Who is Participating?
 
pai_prasadConnect With a Mentor Commented:
can u find out the activity done by this login?
sp_who2

Select *
from sys.dm_exec_connections


just cos u get this error doesn necessarily mean sql wud slow down...

does restart SQL server help?
is there a trace running on?
stop sql agent service and check the log ..r there any jobs which is causing this problem?
r there any 3rd party tools used to monitor sql server ??
0
 
norgrenitAuthor Commented:
I guess my question is, why is this happening, and what can I do to stop it from happening.  My errorlog file is over 110MB now.

Thanks,

Greg
0
All Courses

From novice to tech pro — start learning today.