This morning I have a (2000) server that continually
times out when I try to connect via Ent. Manager. It is
registred through an sa Sql Server login that has not
changed in months. Also, I upped the login timeout in EM
to 10 seconds and it still timed out.
The odd thin is this: I can connect instantly through
Query Analyzer through this same sa login and the server
looks very quiet in Perf Mon.
Is there something different about how Sql Server logins
through Enterprise Manager? Any ideas what would cause
this?The login process should be the same. Though, EM will try to execute a bunch
of queries after a successful login to get server/database properties.
Try up the timeout to at least 60 seconds.
-oj
"Stsh" <anonymous@.discussions.microsoft.com> wrote in message
news:057301c53ebe$672f0410$a501280a@.phx.gbl...
> This morning I have a (2000) server that continually
> times out when I try to connect via Ent. Manager. It is
> registred through an sa Sql Server login that has not
> changed in months. Also, I upped the login timeout in EM
> to 10 seconds and it still timed out.
> The odd thin is this: I can connect instantly through
> Query Analyzer through this same sa login and the server
> looks very quiet in Perf Mon.
> Is there something different about how Sql Server logins
> through Enterprise Manager? Any ideas what would cause
> this?
No comments:
Post a Comment