So yesterday my integration at client T starts throwing errors every 10 minutes just before 8 AM. This integration runs every 10 minutes all day long and reads a file of inventory data from a share on another server. The integration server is our analytics box and the other server is the accounting/GP server.
The first clue as to the problem source was when I logged into the analytics/integration server and could not connect to the accounting server either from SQL Management Studio or via RDP. I opened the Integration Services package that was the source of the errors and it was unable to contact the accounting server. I then tried our SQL Reports hosted on the analytics server and they threw an error as they could not draw data from accounting.
So with those facts in hand I posted IT for assistance. Obviously something had changed to restrict access between the servers.
Magically the problem was resolved by IT. Here is their response.
"Our servers are generally members of three VLANS
and there was a conflict between multiple NICS's, teaming, and VLAN allocation."
No comments:
Post a Comment