DBPROCESS is dead or not enabled

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

DBPROCESS is dead or not enabled

Author

Topic

anniech2000
Starting Member

12 Posts

Posted - 2008-05-28 : 22:00:30

We are running application on Ms SQL Server connecting to PowerBuilder 7.0.3, using MSS Microsoft SQL Server 6.X driver.
We have recently migrated the SQL Server from 2000 to 2005 SP2, in which databases are still at compatability level 80.
The application runs perfectly for one week, but later we received some occassional reports from users that database connection breaks after a

certain idle period. Below are the errors, usually error 1 appears before error 2.

Error 1
A database error has occured.
Database error code: 10025
Database error message:
Select error: Possible network error: Write to SQL Server Failed. General network error. Check your documentation.

Error 2
A database error has occured.
Database error code: 10005
Database error message:
Select error: DBPROCESS is dead or not enabled.

We couldn't find any related errors in the SQL Server log. Does anyone has the idea of what's wrong or how to trace the connection brokerage?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-28 : 23:11:27

Any error on event Log?

mandm
Posting Yak Master

120 Posts

Posted - 2008-05-29 : 09:43:55

This sounds exactly like a problem we experienced a couple of monthes back. It is caused by the SQL Server Keep Alive feature not receiving the proper acknowledgement from the OS and Network card. The following article descibes the issue.

http://support.microsoft.com/kb/942861

We found that an OS patch and a Network Card driver update corrected the problem.

Hope this Helps

riv_luis
Starting Member

1 Post

Posted - 2011-08-15 : 15:26:13

Hi All,

I am having the same problem, an client/server application is running with an SQL Server 2005 in Windows Server 2003 and we are receiving some reports from users that database connection breaks after a certain idle period.

The application was build in Power Builder.

anniech2000, how do you solve your issue??. Any ideas?

Please let me know.

Thanks and regards.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources