Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change default SQL port from 1433/1434 to 9877/9878 Expand / Collapse
Author
Message
Posted Friday, February 01, 2013 7:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:35 AM
Points: 49, Visits: 168
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
Posted Friday, February 01, 2013 9:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

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
Posted Friday, February 01, 2013 9:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:35 AM
Points: 49, Visits: 168
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
Posted Sunday, February 03, 2013 9:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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 »

Add to briefcase

Permissions Expand / Collapse