sql server connection times out
Posted: Wed Jun 03, 2020 6:44 am
Dear Sir,
I have created vpn server on 1 machine and vpn clients on 2 machine
all are windows 10
i am able to sucessfully create a vpn connection and can ping the server.
I cannot have a local bridge as the server is not having physical ehternet adaptor. i am using secure nat
I am also able to sucessfully start my application which runs MSQL server in back end and connect to the SQL server and read write and save.
but if the connection remains idle around 40 to 60 seconds and then attempted to read wrte or save to the sql server the error comes
Run-time error "-2147467259 (80004005): A Connection failure
and the application closes
on restart the application connects again to the sql server and performs function as long as it is not left idle
Kindly help
Regards
Latish Setpal
using "vpnazure.net" for remote access PC to PC
I have created vpn server on 1 machine and vpn clients on 2 machine
all are windows 10
i am able to sucessfully create a vpn connection and can ping the server.
I cannot have a local bridge as the server is not having physical ehternet adaptor. i am using secure nat
I am also able to sucessfully start my application which runs MSQL server in back end and connect to the SQL server and read write and save.
but if the connection remains idle around 40 to 60 seconds and then attempted to read wrte or save to the sql server the error comes
Run-time error "-2147467259 (80004005): A Connection failure
and the application closes
on restart the application connects again to the sql server and performs function as long as it is not left idle
Kindly help
Regards
Latish Setpal
using "vpnazure.net" for remote access PC to PC