DBProcess dead or not enabled
-
Hi all
I have come across a erro message " DBprocess is dead or not enabled" on our client side apps, also I wouln't be able to get the list of current activities from enterprise manager on our sql server at the time.
Could anybody know what is this caused by? index? or somthingelse.
Thanks a lot.
-
"DBProcess dead or not enabled" is usually caused by network problems. It is a client-side error that occurs when the connection to SQL Server is terminated unexpectedly (from the client's point of view). A client could also receive this error if a DBA terminated their connection using KILL, for example.
Did the SQL Server crash? Check network connectivity from both the clients and the server itself.
This is rarely (if ever) a problem internal to SQL Server.
-
Here is one case when ee get this error. When ever we lose our network connection. Our application maintains a connection to the DB when ever running. If for some reason the connection gets broken, even if temp. the error pops up.
App writtten in PowerBuilder6.5
Could be something in the WAN/LAN or a bad card. I've even seen bad a power supply cause the problem, because the NIC loses power.
Curtis Smith
SQL Server DBA
Well in worked in Theory ... -
Hi All
Thanks a lot for your responses. One more thing, guys, Does it affect SQL server as well, as I wasn't able to access the "current activities" to get the process info either.
also the server gave me error message "Error 1222, lock time out"
-
doesn't really affect SQL server. You get that error sometimes when the server is to "busy" to give you the current activity. I think it's a problem with Enterprise Mgr, because if you use query Ana and run sp_who or sp_who2 results come back ok
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply