Re: SQL 2000 drops connection, DDOS attack?

Dan,

Run-time error '-2147467259 (80004005)':

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

Hope this helps. Thanks

"Dan Guzman" wrote:

What's the exact error you get from the application? If it's a 'general
network error', you might try using a different protocol. This can be done
using the Client Network utility or specified in the connection string.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3792EA5E-A646-400F-BE69-3B633807297E@xxxxxxxxxxxxxxxx
Dan,

I have tried this one before and it still doesn't get around the problem:
1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
3. On the Edit menu, point to New, and then click DWORD Value.
4. Type SynAttackProtect, and then press ENTER.
5. On the Edit menu, click Modify.
6. In the Value data box, type 00000000. Click OK.
7. Quit Registry Editor.

Any other ideas please?? I would have thought this would have sorted it,
but
no. Please help. Thanks

"Dan Guzman" wrote:

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






.

Relevant Pages

  • Re: SQL 2000 drops connection, DDOS attack?
    ... network error', you might try using a different protocol. ... using the Client Network utility or specified in the connection string. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.access.security)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)