3

I have an OpenVPN network consisting of VPN server (Linux), client (win8) and SQL Server (win 2008 server, SQL Server 2005), I'm trying to (of course) connect client to server.

When I try to connect using SQL Server Management Studio, it displays an odd error:

Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to cre ate multiple active connections.
The duration spent while attempting to connect to this server was - [Pre-Login] initialization=580; handshake=865; [Login] ini tialization=0; authentication=2; [Post-Login] complete=58013;

The same happens when I try to connect from my (.NET) application - just hangs until the ConnectionTimeout has been reached throwing the same exception.

Curious thing is that I CAN successfully connect using sqlcmd from client and sqlsh+jTDS from OpenVPN server. Nothing shows up in SQL Server error logs or event log, netstat tells that the connection is in established state. Firewalls are off and I have tried every concise mix of connection string parameters, network parameters tweaking and still nothing. I have even tried bouncing the connection off a vpn server - same results.

Any ideas?

Improve this question
3
  • We're having the same issue using a VPN network of two Windows Server 2008 machines
    – CodingBarfield
    Commented Jan 20, 2014 at 9:55
  • For the server name, are you providing an IP address or fully-qualified domain name?
    – MattyZDBA
    Commented Jan 27, 2014 at 17:04
  • I'm providing an IP address.
    – Sasa B
    Commented Jan 29, 2014 at 11:55

1 Answer 1

Reset to default
2

For a better analysis please provide a network dump (wireshark) from the client. A typical problem with vpn is ip fragmentation. This would explain the established state in netstat and that it is working with another client (which might using smaller packets). But without trace it is just a wild guess.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.