Connection Timeout Expired (0x80131904) - Firewall involved

Category: sql server smodmo

Question

chklap on Fri, 07 Aug 2015 16:25:06


I am running a new installation of SQL Server 2012 on Windows Server 2012. I am developing a .Net application. It runs OK on the server itself with the firewall running. However, I get the timeout error when trying to run the application on a LAN host.

I have checked the firewall settings and can see nothing wrong. In the SQL Server Network Configuration:

Windows Firewall opened TCP/1433
Any local IP address
Any remote IP address
Profile - Private

SQL Server Configuration Manager
SQL Server Network Configuration
Protocols for MSSQLSERVER
Shared Memory Enabled
Named Pipes Enabled
TCP/IP Enabled
IP1
Active - Yes
Enabled - Yes
IP Address - 192.168.2.5 (localhost)
TCP Dynamic Ports -
TCP Port - 1433

The LAN host trying to connect and getting the error is a Windows 7 PC. The application is written using .Net 4.5.

I would appreciate any help or suggestions, thanks


Replies

Olaf Helper on Fri, 07 Aug 2015 16:46:19


 See Configure the Windows Firewall to Allow SQL Server Access for how to setup firewall correctly

chklap on Sat, 08 Aug 2015 00:19:01


From SQL Server:

2015-08-07 13:43:12.120	spid10s	Server is listening on [ 'any' <ipv4> 1433].
2015-08-07 13:43:12.120	spid10s	Server is listening on [ 'any' <ipv6> 1433].

Firewall is open onTCP/ 1433, Profile - Private, Scope - Local IP Address - 192.168.2.0/24

Windows Server 2012 is at 192.168.2.5

chklap on Tue, 11 Aug 2015 15:40:25


No help?

I had referred to the quoted article and checked off all suggestions before submitting my problem.

Any suggestions?