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

Question

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

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

sn@ke SSC Journeyman Points: 95 More actions · Answer 1

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

I assume you got that from here?

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

Perry Whittle SSC Guru Points: 234065 More actions · Answer 3

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" 😉