How to change from Dynamic Ports to Static Ports on SQL Cluster?

Discussion in 'microsoft.public.sqlserver.clustering' started by Ken, May 28, 2009.

  1. Ken

    Ken Guest

    I am not sure if this should be posted in SQL Server 2008 Setup or here:

    We are planning to move a middle tier machine into our DMZ. Our clients will
    be connecting to the middle tier machine with a .NET application using web
    services. The web services on the middle tier machine currently connect to
    our SQL Server 2008 environment to move data between the SQL Server and the
    Client Application. We currently have a 2 node SQL 2008 Active/Active Cluster
    on 2 node Windows 2003 Cluster. When set up the default installation created
    the settings for the IPAll as displayed below for SQL1 and SQL2. We need to
    change these settings from TCP Dynamic Ports to TCP Port 1433 on both servers
    for security purposes. What are the best practices for making this change in
    the environment above? Is there any istructions anywhere from Microsoft to
    make this
    change on an existing cluster? How do we make the change without the
    checkpointing to the quorum changing the Ports back? Do we need to take the
    SQL Service offiline? What are the recommended steps?

    TCP Dynamic Ports 1304
    TCP Port

    TCP Dynamic Ports 1717
    TCP Port
    Ken, May 28, 2009
    1. Advertisements

  2. Ken

    Linchi Shea Guest

    Did you try Configuration Manager? If the SQL instance is under the cluster
    control, there is no quorum checkpoint changing it back. Rather, the
    cluster/quorum checkpoint will replicate the change to the other node. Did
    you run into any issue?

    Linchi Shea, Jun 2, 2009
    1. Advertisements

  3. Ken

    Ken Guest

    Linchi thanks for your reply. We haven't actually tried to make the change
    yet. We are looking for guidence on making this change, since it is on a SQL
    cluster, built on top of a Windows cluster and these kinds of changes can
    become complex. We have another question also. When we change this port is it
    recommended to use the default port 1433 or another port?
    Ken, Jun 2, 2009
  4. Ken

    Linchi Shea Guest

    Different places have different guidelines for picking a port. I personally
    don't see a problem wiht using the default port of 1433. In fact, it's often
    convenient to use it as you then don't depend on SQL Browser. But some people
    are hyper about port 1433 being not as secure as some other port.

    Linchi Shea, Jun 2, 2009
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.