Post reply

Changing the Port Number from 1433

  • September 6, 2005 at 10:32 am

    #94870

    Hello,

    If I want to change the port number a for SQL Server single instance, currently using the default port 1433, what port number(s) should I consider?

    Also, what other fall-out can I expect after this is changed?

    Thanks,

    Steve DiDomenico

    Nashua, NH

  • September 6, 2005 at 10:58 am

    #587860

    I can't say which one to use, but make sure it's above 1023 (I believe that's the end of the 'commonly used' Ports).

    There's one big issue with changing ports, how do your users/clients connect? If via ODBC, each user/client must be updated to use the new port for their connection.

    -SQLBill

  • September 6, 2005 at 10:59 am

    #587861

    One more issue, the port might have to be opened on the firewall.

    -SQLBill

  • September 6, 2005 at 12:29 pm

    #587882

    Thanks SQLBill, I pased this along to our Networking folks.

  • September 7, 2005 at 4:02 am

    #588024

    If port 0 is used the SQL will select the port for you.

    You may use any unused port but stay away from the common ports.

    Do not use port 1434.

    All users will need to be sure to use the current MDAC.

    If access is from the outside of you company or the DMZ then the firewall needs to allow you choice of ports and IP address.

     

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

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