What ports does SQL Server require to communicate with a web server?

To resolve what port does SQL Server use, I would suggest following the guidelines provided by Microsoft here: TCP/IP port numbers required to communicate to SQL overall a firewall By default, when an application requests a socket from the system for an outbound call, a port number between the values of 1024 and 5000 is supplied. You brought up the above statement in your comments to the other answers. This is something you have to handle on your firewall. The client chooses the port it wants to be communicated back on. As stated later down in the article above your firewall rules have to allow the dynamic allocation to occur. I don't work with the application side but there might be something you do to force the port it wants to talk on.