Sql Server won't talk to External Web Server

[duckweb]

Here is my problem:

We have a SQL Server box behind our corporate firewall, in our data center. We can hit this box via the Intranet all day long with no problems.

However, we now need to hit this box from our web server, which is hosted externally via another hosting company. We have opened up inbound/outbound traffic on port 1433, but when we try to hit the sql server from the external web server, the webpage just times out.

I don't know if we have a problem on our end, possibly the firewall or if it's something different. Anyone have any ideas?

 

[mrdenny]

There could be firewall/ACL problems at the web hosting companies end, or on some router inbetween.

Many companies (especially hosting companies) do not allow traffic on port 1433 out of there network, as it is usually caused by a virus such as SQL Slammer.

Check with the hosting company, it's probably there firewall or ACL.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[duckweb]

Nevermind....the problem was that I was missing 1 parameter in my connection string

Network Library=dbmssocn

Apparently to connect to sql server behind a firewall you must have that in the con. string.

Lesson learned. thanks for the reply.