question

rahultiwai7 avatar image
rahultiwai7 asked

SQL State error 08s01 error 109

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?

sql server 2008 r2job failure
sql-error.jpg (190.8 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What's the server configuration? Is it virtual or physical? CPUs? RAM? anything else running on the server?

0 Likes 0 ·

1 Answer

·
rahultiwai7 avatar image
rahultiwai7 answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.