locked
3-tier setup, in this topology does WEB server need DB connection enabled RRS feed

  • Question

  • Hi,

    For my new application I need to setup a 3-tier topology (web , app & db server) on VM and DB is behind a firewall. When comes to firewall its always the question what port to be opened and it is UNI / BI.

    My question is if I add a WEB server (WFE) to existing farm do I need to add rules in firewall to open SQL ports for the WEB server IP. I already have added rule in firewall to open SQL connection for APP server.

    Tks

    Hari

    Thursday, January 9, 2014 7:36 AM

Answers

  • Hi Marek Chmel,

    got it. Noted with thanks.

    Tks,

    Hari

    • Marked as answer by Hari Bala Thursday, January 9, 2014 10:31 AM
    Thursday, January 9, 2014 10:31 AM

All replies

  • Sorry forgot ..

    To add on. Does this firewall rule need BI / UNI direction.

    Tks

    Hari

    Thursday, January 9, 2014 7:37 AM
  • Both WFE and APP servers need a connection to SQL server, so you need firewall rules for both. The communication is initiated by SP servers to SQL server. Standard ports are 1433, if you are using named instances for SQL then also 1434 and the port of the named instance.

    Marek Chmel(MVP SQL Server, MCSE SharePoint 2013, MCT, CCNA,CCDA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Thursday, January 9, 2014 8:26 AM
  • Hi Marek Chmel,

    got it. Noted with thanks.

    Tks,

    Hari

    • Marked as answer by Hari Bala Thursday, January 9, 2014 10:31 AM
    Thursday, January 9, 2014 10:31 AM