Page 1 of 1

sql server connection times out

Posted: Wed Jun 03, 2020 6:44 am
by latishs
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

Re: sql server connection times out

Posted: Wed Jun 03, 2020 10:41 am
by cedar
原因はわかっていませんが、SecureNATを通してMS-SQLの長い時間を要するクエリを発行したときに、通信が切断される問題が見つかっています。
SecureNAT以外の方法を使って接続してください。

Re: sql server connection times out

Posted: Wed Jun 03, 2020 4:27 pm
by latishs
Thank you for your reply. I understand u want me not to use secure NAT.
But as my server is my laptop and it does not have a physical ethernet adaptor i cannot use local bridge.
Is there any way out.
I changed the config file to allow all adaptors to allow
but if i bridge to WIFI adaptor it gives a problem.
Hoping for some solutions

Re: sql server connection times out

Posted: Wed Jun 03, 2020 8:47 pm
by cedar
SecureNAT のバグが原因なので、他のNATやルーティングを使うのであれば問題ないのではないかと思います。
例えば VPN Server 側にも VPN Client を導入して NAT32 でルーティングを行うのはどうでしょうか。

Re: sql server connection times out

Posted: Mon Jun 08, 2020 3:39 pm
by latishs
Thank you and appologize for delay in replying

How do i do "For example, how about introducing VPN Client on the VPN Server side and performing NAT32 routing?"

any url link so i will follow instrucutions and try,

Thank you

Re: sql server connection times out

Posted: Mon Jun 08, 2020 8:25 pm
by cedar
SoftEther VPN Client の導入方法が分かりませんか?
それともNAT32の使用方法が分かりませんか?

Re: sql server connection times out

Posted: Wed Jun 10, 2020 12:39 pm
by latishs
Dont know how to use Nat32

Re: sql server connection times out

Posted: Wed Jun 10, 2020 1:42 pm
by cedar
あなたは仮想LANカードをプライベートネットワークに割り当て、イーサネットをインターネットに割り当てるだけで、他の設定は必要ないと思う。