Post reply

Opening 1433 port for SQL Server cluster

  • June 21, 2015 at 10:37 pm

    #319187

    Experts,

    SQL Server 2012 two node single instance cluster.

    For DB access from application severs, do we need to open port (1433) for NODE IPs too ?

    Or is it enough if we open the port 1433 only for VIRTUAL IP ?

    Thanks in advance,

    San.

  • June 22, 2015 at 1:57 am

    #1806941

    The clients will never use the node IP address to connect to SQL Server. Just open the port on the virtual IP address.

    -- Gianluca Sartori

  • June 22, 2015 at 4:00 am

    #1806975

    Thank you very much.

    Was checking for such a specific answer, clear now.

  • June 22, 2015 at 12:22 pm

    #1807151

    if you limit your access on a per client basis (ie server1 connect to dbserver on port 1433, instead of everybody to dbserver on port 1433) then, if you have any outbound traffic(linked servers, file transfers, etc) from the sql cluster then you would need to allow both physical nodes as your client, outbound traffic is from physical node not virtual IP

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • June 22, 2015 at 7:45 pm

    #1807235

    Thanks Robert, understood.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply