Post reply

How to assign static port to SQL Server 2008 Cluster instance

  • April 8, 2011 at 2:40 am

    #389233

    Hi guy's

    I have to put my SQL Server 2008 Cluster behind a firewall. I am now wondering how to configure the static port in cluster.

    Can some one tell me how to do?

    Many thanks for your help

    Rene

  • April 8, 2011 at 4:59 am

    #1309048

    You may find this article useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • April 8, 2011 at 5:14 am

    #1309054

    Hi Adiga

    Thank you for the link. I already read this link but the Q is "How I have to chage in a clustered environement?"

    I'm running Windows 2008 SP2 Enterprise and SQL Server 2008 SP2 Enterprise and in Cluster.

    What I have to do to change from dynamic port to static port?

    Do you have any ideas?

    Thank you.

  • April 8, 2011 at 5:26 am

    #1309056

    Hi all

    I found the solution. It is so simple.:-D

    In "SQL Server Configuration Manager" under "SQL Server Network Configuration" / "TCP/IP" -Properties - IP Addresses - IP ALL

    Clear TCP Dynamic Port

    Set TCP Port as you like

    After that change restart SQL Service and check port settings.

    Do a failover and check port setting on the ohter nodes

    Done.

    Have a nice day.

  • April 8, 2011 at 5:40 am

    #1309060

    Don't forget to configure your Windows firewall to open the port you just changed it to.

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

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