SR DAL Error 6522 - Solution
Hi Community, We have been seeing a spate of these errors on client sites, it seems to be a result of a recent .Net Framework security update, installing a new SystemMessaging.dll file. This file is required by the SRDAL to interact with the Tax database, in a VIZPOST scenario (sites without PM Plus). The issue presents with the following: SR DAL data source server error (see server event log) Assuming the SR DAL service is running and working correctly (and appropriate Windows firewall rules are in place), then the next thing to check is the event log error message. In the Event Log: Applications and Services Logs -> MYOB look for the following: System Release DAL SQL error 6522: [Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "MSync_SqlMsmq2SendMSMQMessage": System.IO.FileLoadException: Could not load file or assembly 'System.Messaging, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050) See Microsoft Knowledge Base article 949080 for more [SELECT CURSOR] Once this is confirmed as the issue, you then need to confirm the current version of .Net and update the assembly security in the Tax database. 1. Open Windows Explorer 2. Browse to C:\Windows\Microsoft.NET\Framework 3. Confirm the folder with the highest number, this is currently v4.0.30319 4. Open SQL Management Studio and login as an administrator account 5. Ensure all users have exited MYOB AE and perform a backup. 6. Select the New Query button 7. Select your AETAX database from the drop down, please note this may not be called AETAX. 8. Enter in the following to the SQL Query, where the folder version number is the one confirmed in step 3. For this example, I will use the current version of 4.0.30319: ALTER ASSEMBLY [System.Messaging] FROM 'C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\System.Messaging.dll' 9. Press F5 or select the !Execute button to run the script 10. You should receive a message the change was made successfully. 11. Confirm Tax now opens and the data can be accessed. Please note: for sites running Profiles, it is also possible to correct this issue by running the AETAXConfigUpdate.exe routine from the MYOB BIN folder. Just make sure all staff are out of MYOB AE and a backup has been performed. As always, this information is provided "as is" and no responsibility will be taken for its misuse or damage caused by these steps. If you are do not understand what the above steps do, please do not attempt them. If in doubt, contact MYOB support :)
Guide: Workstation Installation for Accountants Office
Hello everyone. We've published a quick guide to completing a workstation installation for Accountants Enterprise on your workstation. These instructions apply to the following products: AO Tax (NZ) AO Practice Manager (NZ) AO Practice Manager (AU) AO Workpapers (AU) AO Statutory Reporter (AU) AO Tax (AU) If you've installed MYOB Accountants Office (AO) on a client server or peer-to-peer network you'll need to run a workstation installation to allow the workstations on your network access to the latest MYOB AO. Before you begin: Make sure you're logged onto the workstation as an administrator. Disable User Account Control for the duration of the install. If you change settings, make sure to reboot the workstation prior to continuing. Enable linked connections - make sure to reboot the workstation after applying this setting. Ensure any anti-virus programs have been disabled that may be operating on the workstation. To run a workstation installation for Accountants Office (AO): Open Windows Explorer and navigate to: \\servername\MYOBAO\AOSQL\WorkstationInstall, where: servername is the name of the server or computer on which you performed the server installation. Double-click on setup.exe. The Licence Agreement window appears. Follow the prompts to continue installation. Click Finish. The workstation installation is complete
