Any one help me how can to Change default SQL port from 1433/1434 to 9877/9878, if i change is that portt will be changing in Cluster listener in Always on also ?
i am not able find the Port 1434.
In configuration manager-->Tcp/Ip--> Id address i can see only 1433..
I am not sure you can explicitly change the port for the DAC listener from 1434 TCP. If 1434 TCP is in use when SQL Server starts up the engine will look for and assign a random port.
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato