Re: Blocking UDP Port 1434

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 03/31/04


Date: Wed, 31 Mar 2004 12:01:19 +0530

Not sure if this is of use to you. But still... You can configure SQL Server
to Listen on multiple ports. Refer to the KB article :
http://support.microsoft.com/default.aspx?scid=kb;en-us;294453 for further
information.

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Wayne" <anonymous@discussions.microsoft.com> wrote in message
news:15eb901c416ab$59b613a0$a501280a@phx.gbl...
> We are talking about thousands of clients and I am not
> sure all applications support the use of aliases. Is there
> an easy way out? Will the use of Proxy Server be a better
> choice? Thanks for your input!
>
> >-----Original Message-----
> >No. You can use client aliases to enable clients to
> resolve named instance
> >network endpoints
> >
> >-- 
> >HTH
> >
> >Jasper Smith (SQL Server MVP)
> >
> >I support PASS - the definitive, global
> >community for SQL Server professionals -
> >http://www.sqlpass.org
> >
> >
> >"Wayne" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:15ca401c41699$7b2a65c0$a301280a@phx.gbl...
> >> In order to protect from 'slammer' kind of virus, we are
> >> planning to block UDP Port 1434 on all gateways. Named
> >> instances seem to rely on UDP Port 1434. Since TCP port
> >> the sql instance is listening on can be re-assigned, Can
> >> we reassign the UDP port 1434 as well? Any input will be
> >> appreciated. Thank you!
> >>
> >
> >
> >.
> >


Relevant Pages

  • Re: IIS, SQL 2000 & XPs Firewall
    ... Queries to the Data Engine must go to the port that SQL Server is listening ... More info: How to: Configure a Windows Firewall for Database Engine Access ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote connection problems
    ... tab has Listen All as Yes, then the individual settings for IP1 and IP2 are ... like you are listening on dynamic ports and it is currently listening on ... different port. ... and pick a port number you like, and then restart SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Connecting to DB with Static IP over the internet
    ... port and dmz was forward to the incorect internal ip address:) ... and any other ms sql server related ports on the server. ... item on the connection string. ... is listening, I do netstat -a and it does list that it is being listened ...
    (microsoft.public.sqlserver.setup)
  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Server not listening on 1433
    ... sql server may be listening in a different port. ... >>> Server error log. ...
    (microsoft.public.sqlserver.setup)