Betr.: Strange behaviour of MS SQL 2000
From: Philip Wagenaar (p.wagenaar_at_accon.nl)
Date: 11/24/03
- Previous message: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "TechNet Security Webcast Week"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Nov 2003 15:49:58 +0100 To: <focus-ms@securityfocus.com>
There are numerous reasons why this is happening. It does not even have to be security related.
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@accon.nl
http://www.accon.nl
>>> "Gianni Arru" <arru@comi.it> 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@comi.it --------------------------------------------------------------------------- --------------------------------------------------------------------------- ################################################################## 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 ##################################################################################### --------------------------------------------------------------------------- ---------------------------------------------------------------------------
- Previous message: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "TechNet Security Webcast Week"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
