>>> "Gianni Arru" <arru (at) comi (dot) it [email concealed]> 21-11-03 11:47 >>>
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 (at) comi (dot) it [email concealed]
Dit e-mailbericht is uitsluitend bestemd voor de geadresseerde.
De informatie hierin is vertrouwelijk, zodat het derden niet is
toegestaan om daarvan kennis te nemen of dit te verstrekken aan
andere derden. Indien u dit e-mail bericht ontvangt terwijl het
niet voor u bestemd is, verzoeken wij u contact op te nemen met
de afzender en de informatie te verwijderen van iedere computer.
Bij voorbaat dank.
The information transmitted in this e-mail is intended only for
the person or entity to which it is addressed and contains
confidential information. Any review, retransmission or other
use by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the
sender and delete the material from any computer. Thank you.
########################################################################
#############
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
########################################################################
#############
To get you started.
See what happens when you:
Unplug network cable from the server.
Terminate SQL Server services
Run a IDS
Virusscan the machine
It is possible that a sql job is taking up all server resources. Monitor SQL activity.
Backup the database and restore it onto another machine (clean install, with all updates) and see what happens to that machine...
these are just some basic things to narrow down the source of your problem
Met vriendelijke groet,
Philip Wagenaar
AccoN Accountants & Adviseurs
ICT Project Bureau
Postbus 5090
6802 EB Arnhem
The Netherlands
tel. +31 (0)26-3842384
fax. +31 (0)26-3630222
mobile: +31 (0)6-25388935
MSN/E-mail: p.wagenaar (at) accon (dot) nl [email concealed]
http://www.accon.nl
>>> "Gianni Arru" <arru (at) comi (dot) it [email concealed]> 21-11-03 11:47 >>>
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 (at) comi (dot) it [email concealed]
------------------------------------------------------------------------
---
------------------------------------------------------------------------
---
##################################################################
Dit e-mailbericht is uitsluitend bestemd voor de geadresseerde.
De informatie hierin is vertrouwelijk, zodat het derden niet is
toegestaan om daarvan kennis te nemen of dit te verstrekken aan
andere derden. Indien u dit e-mail bericht ontvangt terwijl het
niet voor u bestemd is, verzoeken wij u contact op te nemen met
de afzender en de informatie te verwijderen van iedere computer.
Bij voorbaat dank.
==================================================================
The information transmitted in this e-mail is intended only for
the person or entity to which it is addressed and contains
confidential information. Any review, retransmission or other
use by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the
sender and delete the material from any computer. Thank you.
##################################################################
########################################################################
#############
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
########################################################################
#############
------------------------------------------------------------------------
---
------------------------------------------------------------------------
---
[ reply ]