Home Forums SQL Server 2012 SQL 2012 - General Change default SQL port from 1433/1434 to 9877/9878 RE: Change default SQL port from 1433/1434 to 9877/9878

  • February 1, 2013 at 9:48 am

    #1583502

    ratheesh4sql (2/1/2013)

    Hi,

    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