I have a bcp out command running on Server A. The command runs against different Servers ( e.g. B, C, D ). It extracts Data from Tables on these Servers. This command runs as part of a cmd job daily. Sometimes, however, it fails with the following error :
SQLState = 08001, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection
When I tested this command, I did not get any error. We get this error randomly.
Any help is appreciated.