DB Process Is Dead Or Not Enabled

We are running a vendor application, and during certain times during
the day we are getting a DB Process Is Dead Or Not Enabled. This is a
SQL Server 2000 database with SP4. The application needs to be shut
down and restarted or the PC needs to be rebooted to get the
application functioning again. The vendor is pointing toward a
Hardware or Network issue. I had a Network Admin check the switches,
ports, and ethernet cards and no problems found. Does anyone have any
ideals on where to look to troubleshoot in SQL Server? Any good
monitoring tools to help troubleshoot this issue? Any help would be
great!I think we need a bit more information here.
TheSQLGuru
President
Indicium Resources, Inc.
<coolsmm@.yahoo.com> wrote in message
news:1181654949.072150.292100@.r19g2000prf.googlegroups.com...
> We are running a vendor application, and during certain times during
> the day we are getting a DB Process Is Dead Or Not Enabled. This is a
> SQL Server 2000 database with SP4. The application needs to be shut
> down and restarted or the PC needs to be rebooted to get the
> application functioning again. The vendor is pointing toward a
> hardware or Network issue. I had a Network Admin check the switches,
> ports, and ethernet cards and no problems found. Does anyone have any
> ideals on where to look to troubleshoot in SQL Server? Any good
> monitoring tools to help troubleshoot this issue? Any help would be
> great!
>|||On Jun 12, 9:56 am, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> I think we need a bit more information here.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> <cool...@.yahoo.com> wrote in message
> news:1181654949.072150.292100@.r19g2000prf.googlegroups.com...
>
>
> - Show quoted text -
The following error message:
DB Error Code: 10005
Error Message: Select error: DBPROCESS is dead or not enabled.
Any ideas on this message?
Does anyone know of a monitoring tool that would monitor the
connection to SQL Server?|||There are a alot of error message 10005 entries on support.microsoft.com,
but not sure that any apply to SQL2K, sp4. Lots of stuff on DCOM issues,
and some SQL7 problems. Perhaps you need to give MS a call? Maybe you
found a new issue.
TheSQLGuru
President
Indicium Resources, Inc.
<coolsmm@.yahoo.com> wrote in message
news:1181664010.062093.320260@.j4g2000prf.googlegroups.com...
> On Jun 12, 9:56 am, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> The following error message:
> DB Error Code: 10005
> Error Message: Select error: DBPROCESS is dead or not enabled.
> Any ideas on this message?
> Does anyone know of a monitoring tool that would monitor the
> connection to SQL Server?
>