sql server connection times out

SoftEther VPN に関するご質問はこのフォーラムにお気軽にご投稿ください。
Post Reply
latishs
Posts: 4
Joined: Wed Jun 03, 2020 6:19 am

sql server connection times out

Post by latishs » 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

cedar
Site Admin
Posts: 1424
Joined: Sat Mar 09, 2013 5:37 am

Re: sql server connection times out

Post by cedar » Wed Jun 03, 2020 10:41 am

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

latishs
Posts: 4
Joined: Wed Jun 03, 2020 6:19 am

Re: sql server connection times out

Post by latishs » Wed Jun 03, 2020 4:27 pm

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

cedar
Site Admin
Posts: 1424
Joined: Sat Mar 09, 2013 5:37 am

Re: sql server connection times out

Post by cedar » Wed Jun 03, 2020 8:47 pm

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

latishs
Posts: 4
Joined: Wed Jun 03, 2020 6:19 am

Re: sql server connection times out

Post by latishs » Mon Jun 08, 2020 3:39 pm

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

cedar
Site Admin
Posts: 1424
Joined: Sat Mar 09, 2013 5:37 am

Re: sql server connection times out

Post by cedar » Mon Jun 08, 2020 8:25 pm

SoftEther VPN Client の導入方法が分かりませんか?
それともNAT32の使用方法が分かりませんか?

latishs
Posts: 4
Joined: Wed Jun 03, 2020 6:19 am

Re: sql server connection times out

Post by latishs » Wed Jun 10, 2020 12:39 pm

Dont know how to use Nat32

cedar
Site Admin
Posts: 1424
Joined: Sat Mar 09, 2013 5:37 am

Re: sql server connection times out

Post by cedar » Wed Jun 10, 2020 1:42 pm

あなたは仮想LANカードをプライベートネットワークに割り当て、イーサネットをインターネットに割り当てるだけで、他の設定は必要ないと思う。

Post Reply