we use sql srv 6.5 in combination with visual basic 5.0
clients. after roughly 3 days online sql server won't react anymore so every client gets a time out. at this point sql srv won't react at all anymore. you can't shut it down nor pause. it always results in physically rebooting the machine. the error log won't give a hint. the last entry in the error log is "won't accept new connections because of 'pause'". 3 secs later it says "will accept new connections because of 'continue'". However, nobody ever touched the machine. the number of connections is still low (according to sys-monitor) and well below the limit set. we applied service pack 4.0 for sql srv and 3.0 for win-nt.