How To Change SQL Server Port In SQL Cluster : Demo

                                Changing Configurations is always confusing task for Junior DBA’s over cluster so if you get task to modify port no. on sql cluster you have to confirm Port no and have to follow below steps to get this done.

When you install sql server on cluster it will start running on dynamic port.

1.      To change Port go to sql configuration manager open server network configuration

2.      Protocols for sql instance for which you want to change port.

3.      Open properties of tcp\ port

4.      Update tcp port value (I am giving XXXX )and remove dynamic port value in end

5.      SQl will ask you to restart sql services when you click apply.

6.      Re-Start sql services from configuration manager. Restarting will not do a failover.

8.      Restarting sql services from configuration will not change port on Passive node. A note here as I never failed back to passive node there is no dynamic port even. If there will be failover then same dynamic port would have reflected here.

8.      You have to do failover to get ports reflected.

9.      Once sql services restarted on passive, you can see port is automatically reflected.

10.      Please follow same on all passive nodes. And sql server will be running on desired node.

11.      Once All done, Please connect to sql server from all nodes and use below query to verify port on sql server.

Please also try to connect to some other server which is not part of cluster to verify SQL is accessible over the network.

No comments:

Post a Comment