Strange behaviour of MS SQL 2000

From: Gianni Arru (arru_at_comi.it)
Date: 11/21/03

  • Next message: Åke: "Re: IIS traffic" 
    To: focus-ms@securityfocus.com
Date: Fri, 21 Nov 2003 11:47:05 +0100

    At the moment I have no idea if this problem is caused by a DOS to our win2000 box or
    is only a bug triggered by some client application that connects to the sql server.

    However this is what it happens:
    - client applications connected to the sql server stop working giving a timeout runtime
    error or freeze if CommandTimeout property is set to 0 in the ADODB.Connection object
    of the client apps.
    - no other clients can connect to the sql server.

    It is possible to login from remote to the server via terminal service and all seems to be
    normal, sql server working, there is no strange disk activity, memory usage or other
    resource leaks.

    The only way to solve this block is to log in and log off on physical console! I'm getting
    crazy! How can be possible that services that run in background are influenced from an
    interactive login on console?

    I've made several analyses using a packet sniffer on the lan and doing sql traces
    running sql profiler and it seems to be all ok but never happend this problem during
    these analyses!

    Thank you in advance for any help. 

    -- 
Gianni Arru
gianni@comi.it
---------------------------------------------------------------------------
---------------------------------------------------------------------------
  • Next message: Åke: "Re: IIS traffic"

    Relevant Pages

    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
      (microsoft.public.sqlserver.connect)
    • Re: Best way to populate webpages from multiple tables
      ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Best way to populate webpages from multiple tables
      ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
      (microsoft.public.sqlserver.connect)
    • Re: SQL and Bandwidth use
      ... In addition to the other responses, take a look at the memory and CPU usage ... in Great Plains Client software. ... > near 100Mb/sec bandwidth). ... Client PC is on same segment as SQL server (not passing through ...
      (microsoft.public.sqlserver.server)