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!
i've already tried adding a server alis in the Client Network Utility.
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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.
Its is possible that this particular fix is not quite the full issue/solution that you are experiencing.
ASKER