Change PORT

[MAK]

Is there any way that I can avoid using 1433,1434 port on the clustered servers?

I have a active/passive (SQL1-active,SQL2-passive) cluster server and another active/passive cluster (SQL2-passive,SQL1-active).

(Its a Quassi active/active server)

I want to change all the sql server ports to other than 1433 and 1434.

Should I change in the registry
Localmachine-software-microsoft-mssqlserver-client-supersocketnetlib-tcp

or
Localmachine-software-microsoft-mssqlserver-mssqlserver-supersocketnetlib-tcpport

or
anywhere else?

Any suggestions are always welcome

[JBane]

Can you change it in the Server Network Utility?

Jeff

[MAK]

But that only changes one port 1433 in registry u can change 1433 and 1434 in VIA

I am doing it in registry. itsworking fine. but i want to make sure from senior senior senior DBAs like u.

[JBane]

Cut it out.
Our cluster isn't exposed to the outside world, so we've never changed those ports. I'm sure someone in the group has...

Jeff

[MAK]

Guys.

How will I know that my server is not using port 1433 and 1434?

[JBane]

That I can answer. Try to connect through query analyzer and use:

servername,port

in the server box. It should fail on 1433 and 1434 if your change was successful.

Jeff

[rmiao]

And you can find out which port sql is listening on in sql server log.

[MAK]

Thanks guys