Hi, i have a MS SQL 2008 Standard Edition server. We are running some SQL jobs to in which last job is to transfer data to our FTP server folder. i am getting SQLstate error (08S01 error 109) it says communication failure but there is no packet drop from and to server. Can you suggest where should i look up?
What's the server configuration? Is it virtual or physical? CPUs? RAM? anything else running on the server?
Windows Server 2012 R2, 32 vCPUs, 48GB RAM, it's a VM. No other application or service is configured on server. I do observed that when i keep the vnc connection with server jobs are running fine. after disconnecting vnc connection, some time later Jobs starts failling.
17 People are following this question.
