Can default and named instance of sql server have same port number?

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

  • No, each instance must have its own port.

    Luis C.
    General Disclaimer:
    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?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • 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[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • 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

    😎

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply