title: An attempt was made to access a socket in a way forbidden by its access permissions
body: <p>I have a website on HostGator and a dedicated server of my own running SQL Server 2008R2. 
  The connection string I use is X.X.X.X,1433 which points to the IP address of my dedicated server.
  I have made the firewall settings on my server so that I can use SSMS &amp; log into SQL Server from my home PC.</p>
  
  <p>Having done that, I was under the impression that connecting to SQL from my hostGator hosted-site would work just fine.
  I receive the following error:</p>
  
  <blockquote>
    <p>A network-related or instance-specific error occurred while establishing a
    connection to SQL Server. The server was not found or was not accessible.
    Verify that the instance name is correct and that SQL Server is configured to
    allow remote connections. (provider: TCP Provider, error: 0 - An attempt was
    made to access a socket in a way forbidden by its access permissions.)</p>
  </blockquote>
  
  <p>I have looked up this error and found many explanations, but not one dealing with my circumstances.
  My server is running Windows 2008 w/IIS 7.5. I was assured by HostGator tech support that there would be no problems from their end.]]</p>
  
  <p>My firewall allows TCP port 1433, &amp; the UDP port 1434 for the SQL Server Browser service.</p>
  
  <p>Since I have a dedicated server, I have no one to ask this question to from my hosting company.</p>