Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2007-11-16
2
Medium Priority
?
1,028 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:norgrenit
2 Comments
 

Author Comment

by:norgrenit
ID: 20300452
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
 
LVL 10

Accepted Solution

by:
pai_prasad earned 750 total points
ID: 20301891
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question