NAT to IIS Server / SQL connections not coming through



  • I'm hoping that someone here can help. I recently implemented pfsense 2.1.5 and all my services are working properly, except for my IIS web server. Basically the server takes request from another web server. The other server call an ASP.net app to query a MSSQL server that also resides on that server the information is then passed back to the primary web server(external) so that the website displays inventory information.

    I cannot figure out how to get this to work. On the old sonicwall firewall everything works great. On pfsense, I've got 1:1 NAT co figured properly (or so I think, since all other services work fine) the webserver has its own dedicated IP as well.

    I've tried the following, still with no luck:

    • created a rule to allow any protocol from * on wan to the web server
    • disabled "block private networks" on WAN interface
    • combination of both with no luck.

    Looking at packets through wirshark, I see that the external server is making the request, but the HTTP packet that is sent back says that there was trouble connecting to the SQL server.

    If anyone has any ideas, I'd appreciate it. This is the last thing I need to fully get my pfsense box up and running.

    Sorry if there's ant typos, I'm on my mobile.

    Cheers.