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 1, 2013 7:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 49, Visits: 178
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 1, 2013 9:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 7,127, Visits: 12,656
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
Post #1414745
Posted Friday, February 1, 2013 9:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 49, Visits: 178
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 3, 2013 9:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 7,127, Visits: 12,656
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
Post #1415100
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse