Troubleshooting: Login error - Unknown Sql Exception (Number=823, Message=The operating system returned error 21(The device is not ready)

From AutoCount Resource Center

Question: When I try to login the account book, it prompts error “Unknown Sql Exception (Number=823, Message=The operating system returned error 21(The device is not ready)”. Why?

Version: 1.8 / 1.9 / 2.0

Devicenotready1a.png


Possible Reason:

This is due to a disk being offline or not being online either at the time SQL Server started or was at transitional state after SQL Server has been online.


Solution:

Restart SQL server services and refresh the database.

1) Search and open Services from window search.

Devicenotready2.png


2) Locate the service called SQL Server (instance name), click on Restart.

Devicenotready3.png


3) Search and open SQL Management Studio from window search.

Devicenotready4.png


4) Connect SQL Server Management Studio.

Devicenotready5.png


5) Right click on your database and click on Refresh.

Devicenotready6.png


6) Try to login AutoCount, you should be able to login now.


By: Tian Neng 221221, Lay Swan 221223, P221227


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations