SQLServerException: TCP/IP connection to the host has failed
sql-server
Solution
Remove All the TCP Dynamic Ports and Add value of 1433 to all TCP Port and restart your SQL Server
Steps
- Open the Sql Server Configuration Manager (Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools)
- Expand SQL Server Network Configuration -> [Your Server Instance]
- Double click TCP/IP
- Under Protocol:Ensure Enabled is Yes
- Under IP Addresses:Scroll to the bottom and set the TCP Port under IPAll, (1433 by default)
- Find the IP address you want to connect to and set Enabled and Active to Yes
Problem
When I am running an Web application, I get an error message "The TCP/IP connection to the host,port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port." The TCP/IP is active and enabled and the TCP port defaults to 1433.,But I still get this error message. Could anyone help me on this?