cold fusion , SQL server

Usual firewall setup would allow all traffic between the servers behind the firewall, so your CF app server should already be able to talk on 1433 to the sql server.

Unless you have multiple zones for your firewall, then it may be possible that 1433 needs to be open to talk to the db server.

Login to the cf server and from the command prompt do> telnet sqlserverhost 1433

if it connects you are fine.

Now the ISS server will require some ports in the 2900+ range (I believe), to be opened.  Since you are running in distributed mode these are the ports the CF IIS connectors try to connect to with your cf app server.

The wsconfig files on your IIS server should have to ports it's attempting to connect to exactly, if everything is already setup with IIS correctly, those ports may already be open.

Curious, that your IIS server is not behind the firewall as well.  This could be done to secure it a bit more, and allow only 80 and 443 traffic to the server.

If you have a network admin, they should be able to assist as well.

Byron Mann

mannb@hostmysite.com

byronosity@gmail.com

Software Architect

hosting.com | hostmysite.com

http://www.hostmysite.com/?utm_source=bb