Troubleshooting: Forgot SA password: Difference between revisions

From AutoCount Resource Center
(Created page with "'''Question''': I have forgotten SA password and unable to attach account book? <u><b>Answer:</b></u> SA password is AutoCount SQL default password. If you have created you...")
 
No edit summary
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
'''Question''': I have forgotten SA password and unable to attach account book?
+
'''Question:''' I have forgotten SA password and unable to attach account book?
  +
  +
<b>Version:</b> 1.8 / 1.9 / 2.0
   
   

Latest revision as of 02:18, 24 February 2020

Question: I have forgotten SA password and unable to attach account book?

Version: 1.8 / 1.9 / 2.0


Answer:

SA password is AutoCount SQL default password. If you have created your own SA password and forgotten, you are not able to Detach/Attach Account Book. To solve this, you need to reset the SA Password, and re-attach all account books for each of the PCs.


If you are using AutoCount Default SA Password, SA password is not needed to attach/detach account book.


To reset SA Password, launch MSSQL Management Studio and login using the authentication mode: “Windows Authentication”.

1. Go to Security > Login > sa > right click Properties


Sql sa.png


2. Key in and confirm new SA password and press OK.


Sql sa1.png


Another option is to use SQL query to update the sa password.

ALTER LOGIN sa WITH PASSWORD='password'


Note:Please do a backup of database before changing anything! As this issue requires some technical skills, kindly consult your software consultant if there is any doubt.


By:KM 170530, 170725; P170801

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


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