Solved

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

Posted on 2007-11-16
2
996 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 250 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now