Post reply

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

  • August 28, 2014 at 1:41 pm

    #310498

    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.

  • August 28, 2014 at 4:58 pm

    #1741773

    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

  • August 28, 2014 at 7:19 pm

    #1741785

    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

  • August 28, 2014 at 10:37 pm

    #1741804

    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