Change default SQL port from 1433/1434 to 9877/9878

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Change default SQL port from 1433/1434 to...

Change default SQL port from 1433/1434 to 9877/9878

Rate Topic

Display Mode

Topic Options

Author

Message

ratheesh4sql

Posted Friday, February 01, 2013 7:52 AM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, March 31, 2013 10:32 AM
Points: 48, Visits: 148

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..

Post #1414689

opc.three

Posted Friday, February 01, 2013 9:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:47 PM
Points: 6,693, Visits: 11,704

ratheesh4sql (2/1/2013)

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414745

ratheesh4sql

Posted Friday, February 01, 2013 9:15 PM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, March 31, 2013 10:32 AM
Points: 48, Visits: 148

SQL port is very well known and can lead to attempted security breach. Much safer on non-standard ports so i planned to change it in my production server.

Post #1414902

opc.three

Posted Sunday, February 03, 2013 9:52 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:47 PM
Points: 6,693, Visits: 11,704

Remote DAC connections are disabled by default so no worries there, just leave them disabled if you're concerned.

SELECT  *
FROM    sys.configurations
WHERE   name = 'remote admin connections';

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1415100

« Prev Topic | Next Topic »

Permissions