Store Operations Business Rules Error - A server failure occurred while attempting to read Cashier

I am having a problem with POS registers recently. Since the last 3 days, when the cashiers log-in to the POS in the morning, the system does not allow them entry (after a minute freeze) and displays the following error message:

Store Operations Business Rules

! Error # -2147217871 Timeout expired (Source: Microsoft OLE DP Provide for SQL Server) (Native Error:0) No Help File Available UPDATECashier SET Failed logon Attempts=0 WHERE Number =?

When I click on ¡®OK¡¯ then I get the following message:

X Server Failure 135 A server failure occurred while attempting to read Cashier Error # -2147217871 (Source: Microsoft OLE DP Provide for SQL Server) (Native Error:0) No Help File Available UPDATECashier SET Failed logon Attempts=0 WHERE Number =?

The only way I could get the system to work again is to restart the backoffice in the morning. Everything is ok then. The same problem re-occurs again the following morning!

I can¡¯t figure out why this problem is occurring all of a sudden. Can anyone tell what to do?

TIA

Problem is fixed now. It turns out that the Database Log file grew to 38 Gbyte!!! And we shrunk it down again.

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:eJj$ snipped-for-privacy@TK2MSFTNGP12.phx.gbl...

Two possibilities:

In either case you need to fix the settings or this problem will return.