<jenny@discussions.microsoft.com> wrote:

>Thx a lot Sue. As a conclusion, do you recommend to block the port 1434 for
>my server hosting a SQL Server using non-default port ?
>
>"Sue Hoegemeier" wrote:
>
>> It's true if they don't specify what port to use. But the
>> port can be specified in the connection string. It's
>> documented in a few places. One particular article notes:
>> If UDP port 1434 is disabled, the SQL Server client cannot
>> dynamically determine the port of the named instance of SQL
>> Server. Therefore, the SQL Server client may not be able to
>> connect to the named instance of SQL Server. In this
>> situation, the SQL Server client must specify the
>> dynamically allocated port where the named instance of SQL
>> Server 2000 is listening. Refer to:
>> How to use static and dynamic port allocation in SQL Server
>> 2000
>> http://support.microsoft.com/?id=823938
>> Also check the references in:
>> INF: TCP Ports Needed for Communication to SQL Server
>> Through a Firewall
>> http://support.microsoft.com/?id=287932
>>
>> -Sue
>>
>> On Mon, 28 Mar 2005 03:03:03 -0800, "jenny"
>> <jenny@discussions.microsoft.com> wrote:
>>
>> >Hi, Thx first. I just heard some application program must have 1434 be
>> >enabled such as Visual Basic. Is that true? By the way, is there any
>> >document mentions about that ? Thx a lot.
>> >
>> >"Sue Hoegemeier" wrote:
>> >
>> >> It's okay - You can hard code the listening port on the
>> >> client side and then block UDP 1434. It won't be needed for
>> >> resolution of the listening port if you essentially are
>> >> telling the client side what port to use.
>> >>
>> >> -Sue
>> >>
>> >> On Sun, 27 Mar 2005 04:39:07 -0800, "jenny"
>> >> <jenny@discussions.microsoft.com> wrote:
>> >>
>> >> >I have two SQL Server installed on a Server. One is using default port 1433,
>> >> >the other is using another port 1400. Due to virus infected, may I block the
>> >> >port 1434 and setting the alias for the non-default port 1400 at the SQL
>> >> >clients? Will there be any other impact ? Thx
>> >>
>> >>
>>
>>