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

Can default and named instance of sql server have same port number? Expand / Collapse
Author
Message
Posted Thursday, August 28, 2014 1:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:15 AM
Points: 37, Visits: 184
Hi!

I want to know by default sql server runs on port 1433.So, if the server has default and named instance , can it both run on port 1433?

Thanks.
Post #1608403
Posted Thursday, August 28, 2014 4:58 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:20 PM
Points: 3,943, Visits: 8,951
No, each instance must have its own port.


Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1608450
Posted Thursday, August 28, 2014 7:19 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 9:51 AM
Points: 5,446, Visits: 7,616
Just to confirm what Luis said... no, you can't. The Port is how it communicates and knows what belongs to it, everything else is an alias.

Why would you want to do this, or even care?



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1608465
Posted Thursday, August 28, 2014 10:37 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:49 PM
Points: 2,420, Visits: 6,736
In my opinion, setting the actual port number for each instance should be avoided unless absolutely necessary. Leave this to the SQL Server Browser Service
Post #1608487
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse