Post reply

TCP PORT

  • October 18, 2011 at 10:45 pm

    #245498

    I have a server in which only a single sql server instance is installed on it.That single instance is a named instance.

    I need to know when we install a single named instance on a server, which port it will defaultly select?(Normal case default instance will go for 1433 and named instance to dynamic).

    Kindly do reply...

  • October 19, 2011 at 3:17 am

    #1396511

    It will default to the dynamic TCP port configured within SQL Server Configuration Manager. You will probably want to change this from a dynamic port to a static port.

    It will not use TCP 1433 unless you specifically change it!

    Regards,

    Mark

  • October 19, 2011 at 3:11 pm

    #1396987

    SQL Server 2005 uses the dynamic port when a named instance is installed. You can change your port to the static port from Configuration Manager.

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

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