Change PORT

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

Can you change it in the Server Network Utility?

Jeff

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.

:D

Cut it out. :eek:
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

Guys.

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

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

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

Thanks guys