Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
1) Use FQDN on the DB Server Instead of IP. If server is not domain based, then add a host entry in ETC\Hosts file and then use the same instead of IP
If that doesn't work, additionally try below
1) Open Windows Firewall on SQL Server and add a rule to unblock inbound port 1433
2) Enable IPV6 in NIC properties of SQL Server.
1) Use FQDN on the DB Server Instead of IP. If server is not domain based, then add a host entry in ETC\Hosts file and then use the same instead of IP
If that doesn't work, additionally try below
1) Open Windows Firewall on SQL Server and add a rule to unblock inbound port 1433
2) Enable IPV6 in NIC properties of SQL Server.
1 comment:
You are a Champion Mate. This Freaking Windows Firewall has been driving me Nuts for a long time.. I really appreciate your help.
Post a Comment