Loss of SQL Server Services

[dwunz]

I having a random problem with SQL Server 2000. The services stop responding and the only indication I get is when I try to access the data base via ODBC and get the following error:

-2147467259-[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation

Stopping the services and restarting them fixes the problem until the next random stop.

Our environment has 4 realtime systems sending data to an application for insertion into the database, and separate user applications for reporting, etc.

At first I thought we were just having a timeout problem, but a pattern has developed requiring stopping and restarting the services.

Has anyone seen this or know where I might start to look?

 

[fluteplr]

I would start by looking at the sql error log and the NT application event log. By default the sql logs are in the log subdirectory of the directory you installed sql in. They are just text files so you can read them with notepad.

 

[KRISF]

Definitely the NT and SQL Server logs are the place to start. If you can use SQL Profiler, it can become an invaluable tool for detecting errors.