Home Forums SQL Server 2012 SQL 2012 - General SQL Server Port Number Assignments - How To Determine What Number To Use RE: SQL Server Port Number Assignments - How To Determine What Number To Use

  • Lynn Pettis (4/15/2013)


    The best I can provide is based on when I was setting up database mirroring. First, iirc, you need to select a port number above 1024, and I thought under 32768. When selecting this port number, work with your network services personnel to help identify an open port or range of open ports you can use such that they can document the port number(s) such that future applicatioins don't suddenly take the port(s) you and Network Services assigned.

    Lynn,

    It sound like the answer is (at least for me) ask your network admin for one or more ports you can use. That would explain why theres no SQL Server spefici hitys on what port number to use but still, it sure would be nioce it at least the Microsoft hosted items said something along the lines of..

    "Unsure of what port number to use when assigning a fixed port to SQL Server? Check with your network admin for a range of valid port numbers to use with the SQL Server instances in your domain". Anything that would let the readr know that POrt Number selection is something that typically is handled by someone else.

    Thanks Lynn

    Kindest Regards,

    Just say No to Facebook!