FAQ: How to Change SA Password?

Do you all know AutoCount is using SQL Server as their database server?

SA Password is SQL default password. If you are using your own SA password, and forgot the SA password, you will be unable to detach/Attach Account book, you need to reset the SA Password in order to attach/detach Account Book. After resetting SA password, you need to re-attach all account books at every pc.

If you are using AutoCount Default Sa Password, then you no need to worry about it.

To reset SA Password, open SQL Management studio and login using the authentication mode: “Windows Authentication”.

Go to Security--> Login -->sa-->right click Properties

 

 

 

Type new SA password in password & confirm password box and press OK.

 

 

 

 



Another option is using sql query to update the sa password.

 

ALTER LOGIN sa WITH PASSWORD='password'

 

 

Please do a backup of database before changing anything!  As this part requires some IT knowledge, please consult with your software dealer for any changes.



 

 

 

MicroSoft Sql Server Limitation

 你可能不知道AutoCount 是使用的数据库服务器为MicroSoft Sql Server。而每个数据库服务器也是有它的限度，意思就是当你的数据库满了或者到达一定的储存量，你就必须做year end closing。当然你也可以选择购买更高版本的SQL Server 比如standard或者enterprise 版本， 就可以支持更高的储存量。 以下就是每个版本的限度

For SQL Express 2005, maximum size limit to 4 GB,
For SQL Express 2008 R2,  Maximum size limit to 10 GB.
For SQL Express 2012, Maximum size limit to 10 GB.
For SQL Express 2014, Maximum size limit to 10 GB.


要如何检查你用的SQL Server 是什么版本？ 去 Helps-->About AutoCount Accounting， 然后就可以知道了。