Post reply

Changing SQl Server default port in SQL Cluster environment.

  • July 18, 2011 at 9:19 pm

    #253938

    Hi Expert,

    What are the steps to change SQL server default port 1433 to some other port in sql server 2008 cluster on windows 2008?

    Can we do this the same way which we usually do from sql configuration manager or we need to follow some other ways in cluster environment?

    Please help.

    Regards,

    Bipan

  • July 19, 2011 at 3:05 am

    #1354668

    Since that is registry information, you will need to do that step on all the cluster nodes.

    remember, there is a trick in setting the listening port, you need to clear the value in "TCP Dynamic Ports" and enter a value in the "TCP Port" setting.

    Cheers!

    ~C

    Craig Outcalt


    Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
    My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

  • July 19, 2011 at 4:59 am

    #1354707

    SQLBOT (7/19/2011)

    Since that is registry information, you will need to do that step on all the cluster nodes.

    remember, there is a trick in setting the listening port, you need to clear the value in "TCP Dynamic Ports" and enter a value in the "TCP Port" setting.

    Cheers!

    ~C

    And you have to repeate it on each node of the cluster.

Viewing 3 posts - 1 through 2 (of 2 total)

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