Post reply

Conditions that cause SQL to change its dynamic listener port.

  • February 2, 2005 at 4:19 pm

    #87386

    I was wondering if anyone could tell me or point me in the direction of a white paper. When SQL 2000 SP3 is configured for dynamic port allocation, what conditions would cause it to change its port? IE I need to be aware of Listener port changes.

    Thanks

    Cody Pack
    MCSE Windows 2000
    MCDBA SQL Server 2000

  • February 3, 2005 at 6:23 am

    #540343

    It will dynamically assign a port on the first start, it reuse from that point forward on subsequent starts. Now however if on a start some other application has taken the port already it will dynamically reassign to the next available port it can find dynamically, and from that point forward it will remain the same untill something takes the port first, so repeat this then.

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

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