Post reply

multi sql-cluster-instances with no default port & no instance name

  • December 9, 2015 at 9:11 am

    #306992

    Hi@All

    Is it possible to configure multi sql-cluster-instances with no default port and the clients connect without a instance name (only servername)?

    for example:

    instance01/name01 Port: 10000

    instance02/name02 Port: 10001

    ...

    client connect with: instance01

    If eache Instance runs with the defaut port.

    This Instruction work only (for me) with port 1433.

    1. On the active node for the instance youre adjusting, open the "SQL Server Configuration Manager" from the start menu.

    2. Expand "SQL Server Network Configuration" and select the instance you want to edit.

    3. In the right window, right-click "TCP/IP" and select "Properties."

    4. On the "Protocol" tab, ensure that "Listen All" is set to "Yes"

    5. On the "IP Addresses" tab, scroll all the way to the bottom, to the "IPAll" section.

    6. The "TCP port" box is blank by default - set it to 1433, the default port for SQL Server.

    7. Click "OK" - youll receive a message that you need to restart the SQL Service.

    8. Restart the SQL Service on that node.

    Are there additional factors?

    Thanks

  • December 16, 2015 at 6:03 am

    #1846277

    Hi@All

    Unfortunately, until now no one could help me :crying:

    Did I described the problem to bad?

    I want to address the cluster instances without an instance name, but without the default port (1433).

    That would simplify migrating to a new cluster.

    thx

  • December 16, 2015 at 8:09 am

    #1846308

    I assume you got that from here?

    http://www.trycatchfinally.net/2009/05/accessing-a-clustered-sql-server-instance-without-the-instance-name/

    Could you just ask your networks people (or whoever does it) to open whichever port it is that you want to use?

  • December 17, 2015 at 6:16 am

    #1846535

    sn@ke (12/9/2015)

    instance01/name01 Port: 10000

    instance02/name02 Port: 10001

    please note, connections should be made to

    instance01ame01

    instance02ame02

    it's not recommended to set 1433 on named instances, use a high range static port for the named instances and 1433 for a default instance

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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