| Author |
Messages |
|
Chad
 |
| 09/25/2002 4:04 PM |
 Quote
 Reply
 Alert
|
| I am getting network logon attempts on my SQL Server 2000 Cluster from users running Enterprise Manager. Administrators of the machine seem to have successful logons while everyone else seems to fail (and retry every few seconds). I have recently installed W2k sp3 and the latest sql server hotfixes and never noticed this issue before. This only occurs with enterprise manager, not with query analyzer or any other software. I think the number of logon attempts is causing my lsass.exe to balloon up (at one point it was >400MB!) and I need to resolve this before I rollout sp3 to production. Any help, recommendations, etc would be appreciated. |
|
|
|
|
Chad
|
| 09/30/2002 10:32 AM |
Quote
Reply
Alert
|
| As an answer to my own question, this was being caused by the polling that Enterprise Manager defaults to running every 10 sec to investigate the state of the sql service. After disabling this for my developers that lsass.exe started shrinking and I stopped getting the logon failures in the event log.
oh yeah, to disable this go to Tools -> Options.. -> uncheck "Poll server to find out state of server and related services"
-Chad |
|
|
|
|
|