title: How to make SqlConnection timeout more quickly
body: <p>I am using an SQL connection string with SqlClient.SqlConnection and specifying Connection Timeout=5 in the string, but it still waits 30 seconds before returning failure.  How do I make it give up and return faster?  I'm on a fast local network and don't want to wait 30 seconds.  The servers that are not turned on take 30 seconds to fail.  This is just a quick utility program that's going to always run just on this local network.</p>
  
  <p><strong>Edit</strong>: Sorry if I was unclear.  I want the SqlConnection.Open to fail more quickly.  Hopefully that could be deduced from the fact that the servers I want to fail more quickly are turned off.</p>
  
  <p><strong>Edit</strong>: It seems that the setting only fails sometimes.  Like it knows the IP address of the server, and is using TCP/IP to talk to it (not local) but can't contact SQL Server at that address?  I'm not sure what the pattern is, but I don't see the problem when connecting locally with SQL Server stopped, and I don't see it when attempting to connect to a non-existent server.  I have seen it when attempting to contact a server where the Windows 2008 firewall is blocking SQL Server, though.</p>