Link to home
Start Free TrialLog in
Avatar of killer5
killer5

asked on

Can't connect using enterprise manager but works with Query Analyzer

I get a "Timeout Expired" error message when connecting through Enterprise Manager.  The weird thing is, i can connect when using query analyzer.

i've already tried adding a server alis in the Client Network Utility.


thanks!
ASKER CERTIFIED SOLUTION
Avatar of danblake
danblake

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of killer5
killer5

ASKER

GOod answer my mehn!!! THANKS A LOT!
I wish MS would create a KB article on this one, It's a common occurance.
Top answer - had me puzzled for a while!! Thanks
I have a similar issue where I'm getting timeouts when I execute a DELETE query from within Enterprise Mannager.  If if execute the same query from Query Analyser its OK.  I also have the query timeout mentioned above set to 0 (although I'm running SQL 7 so its Tools, Otions, Connections.  

Any ideas?
@sonic youth -- you should ask this in a new question.
Its is possible that this particular fix is not quite the full issue/solution that you are experiencing.