Difference between revisions of "Troubleshooting: Failed to login to AutoCount Accounting 1.8 Consolidate Financial Report"

From AutoCount Resource Center
Jump to navigation Jump to search
(Created page with "'''Question:''' Failed to login AutoCount Accounting 1.8 Consolidate Financial Report, error message prompted “Cannot open database “AED_Express” requested by the login....")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
'''Question:''' Failed to login AutoCount Accounting 1.8 Consolidate Financial Report, error message prompted “Cannot open database “AED_Express” requested by the login. The login failed. Login failed for user ‘sa’.”
 
'''Question:''' Failed to login AutoCount Accounting 1.8 Consolidate Financial Report, error message prompted “Cannot open database “AED_Express” requested by the login. The login failed. Login failed for user ‘sa’.”
  
 +
<b>Version:</b> 1.8 / 1.9 / 2.0
  
 
[[File:Login consolidation1.png]]
 
[[File:Login consolidation1.png]]
Line 14: Line 15:
  
  
<u><b>Solution:</b></u>
+
<u><b>Solution (1) :</b></u>
  
 
For this issue, temporary work around solution is to create new account book with the same database name “AED_Express”.  You should be able to login to consolidation mode after created new account book.
 
For this issue, temporary work around solution is to create new account book with the same database name “AED_Express”.  You should be able to login to consolidation mode after created new account book.
Line 37: Line 38:
  
 
[[File:Login consolidation4.png]]
 
[[File:Login consolidation4.png]]
 +
 +
 +
 +
 +
 +
<u><b>Solution (2) :</b></u>
 +
 +
There is another way to delete consolidate profile from SQL Management Studio.<br/>
 +
 +
1) Login to SQL Management Studio, go to <span style='color:red'>Databases</span>, click on <span style='color:red'>AUTOCOUNT_CONSOLIDATE</span>, and click on <span style='color:red'>New Query</span>, type the following SQL query and click on <span style='color:red'>Execute</span>.
 +
 +
 +
This SQL query is to show a listing of relevant files.
 +
 +
 +
'''select * from ConsolidateProfile'''
 +
 +
 +
[[File:Delete consolidate1.png]]
 +
 +
 +
 +
 +
 +
2) To delete all consolidate profiles, type the following SQL query and click on <span style='color:red'>Execute</span>.<br/>
 +
 +
 +
'''delete from ConsolidateProfile'''
 +
 +
 +
[[File:Delete consolidate2.png]]
 +
 +
 +
Now, you should be able to login Consolidated account book, and you may maintain new consolidate profile.
 +
 +
 +
'''Note :''' To delete a specific consolidate profile only, just add a condition at SQL query.<br/>
 +
 +
 +
<u><b>Example :</b></u>
 +
 +
 +
'''delete from ConsolidateProfile where AccountBookKey = X''' (value X can obtain from the result of the first SQL query)
 +
  
  
Line 42: Line 87:
 
By: Julee 180302, Km 180305, P180308
 
By: Julee 180302, Km 180305, P180308
  
 +
 +
By : Ashikin 200320, Lay Swan 200326, P200327
  
  
 
{{NavigateForUser}}
 
{{NavigateForUser}}
 +
 +
[[Category:Users]]

Latest revision as of 02:52, 30 March 2020

Question: Failed to login AutoCount Accounting 1.8 Consolidate Financial Report, error message prompted “Cannot open database “AED_Express” requested by the login. The login failed. Login failed for user ‘sa’.”

Version: 1.8 / 1.9 / 2.0

Login consolidation1.png



Possible Reason:

The database previously set in consolidated profile has been deleted. However, the configuration in consolidated profile hasn’t been cleared. Thus, you can’t login to any account book in consolidation mode to consolidate financial report.



Solution (1) :

For this issue, temporary work around solution is to create new account book with the same database name “AED_Express”. You should be able to login to consolidation mode after created new account book.

To delete this account book from consolidated profile,

Login to any account book in consolidation mode and click on Consolidate Profile.


Login consolidation2.png


Select account book you wish to delete from the consolidated profile and click on Delete.


Login consolidation3.png


Click on Yes to delete the record.


Login consolidation4.png



Solution (2) :

There is another way to delete consolidate profile from SQL Management Studio.

1) Login to SQL Management Studio, go to Databases, click on AUTOCOUNT_CONSOLIDATE, and click on New Query, type the following SQL query and click on Execute.


This SQL query is to show a listing of relevant files.


select * from ConsolidateProfile


Delete consolidate1.png



2) To delete all consolidate profiles, type the following SQL query and click on Execute.


delete from ConsolidateProfile


Delete consolidate2.png


Now, you should be able to login Consolidated account book, and you may maintain new consolidate profile.


Note : To delete a specific consolidate profile only, just add a condition at SQL query.


Example :


delete from ConsolidateProfile where AccountBookKey = X (value X can obtain from the result of the first SQL query)



By: Julee 180302, Km 180305, P180308


By : Ashikin 200320, Lay Swan 200326, P200327



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