January 25, 2006 at 12:38 am
Hi,
Is it possible to configure a setting for dynamic ports when deploying a named instance?
[DlgServerNetwork-0]
TCPPort = ?
Cheers.
January 27, 2006 at 9:08 am
hi,
Sql listens to number of port a part from default.
It is not possible to configure sq server to listen on dynamic port numbers.
HTH
from
Killer
January 27, 2006 at 11:02 am
No; the first instance listens on 1433 by default - subsequent instances, named instances, defaults to dynamically allocating a port. See:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;823938
However, when using the setup.iss to create a named instance in an unattended installation it appears to be required to define a port.
April 21, 2006 at 1:21 pm
In a named instance.
Leaving the TCPPort = 0 will cause it to become dynamic
[DlgServerNetwork-0]
NetworkLibs=255
TCPPort=0
TCPPrxy=Default
NMPPipeName=\\.\pipe\MSSQL$PRD01\sql\query
Result=1
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply