Activity overview
Latest activity by JLankford
The issue is random; not consistent. I may very well run a simple or a more complex query one time and it run fine, immediately execute it again and it may fail the 2nd time. I administer ~100 SQL Servers globally, and they all have a standard configuration - which is pretty much the default when it comes to network settings - yes, they are using port 1433 over TCP/IP and Named Pipes.
Also, I will emphasize that even while I am having these issues with Multi-Script - I do not have them at all when using SQL Query Analyzer or Enterprise manager to connect to the servers.
Thanks,
James / comments
The issue is random; not consistent. I may very well run a simple or a more complex query one time and it run fine, immediately execute it again and it may fail the 2nd time. I administer ~100 SQL ...
Random connection failures when executing remote queries
I am getting random connection failures when I run different types of queries:
"Msg 2, Level 20, State 0, Line 0
An error has occurred while establishing a connection to the server. When connectin...