Re: SQL 2000 drops connection, DDOS attack?
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Feb 2006 07:55:19 -0600
Check out http://support.microsoft.com/kb/899599/en-us
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A0620D88-A311-4346-A903-9556A66C40A8@xxxxxxxxxxxxxxxx
This is relating to SQL slammer question I posted.
We open 1 connection to SQL and we're
opening multiple recordsets, literally 1000s at a time. If you run it on
the
server that is running SQL 2000 it's fine...but do this from a client PC
then
you get a general network error. It's dropping the initial SQL connection
halfway through running a recordset lookup and causes an error...as the
connection has been dropped. We can put a 30 second delay in there and
this
gets around the problem, while it restablishes the connection, but this is
not practical. There must be something that can be done to tell SQL 2000
or
server 2003 sp1 to leave the connection alone when it's connected?? Any
ideas
anyone? Thanks
.
- Prev by Date: Re: Any valid login can access Enterprise Manager
- Next by Date: Re: Any valid login can access Enterprise Manager
- Previous by thread: Re: SSPI handshake failed with error code 0x8009030c
- Next by thread: Re: SQL 2000 drops connection, DDOS attack?
- Index(es):
Relevant Pages
|
|
