Error: "SR DAL data source error"

This support note applies to:

AE Tax Series 6 & 8 (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 30952

This KB is relevant if you use AE Tax series 6/8

In MYOB Accountants Enterprise (AE) Tax, you might see the error "SR DAL data source error " when opening tax returns after a Windows .NET Framework update.

The event log shows:

System Release DAL SQL error 6522: [Microsoft][ODBC SQL Server Driver][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 informa[]

To open a tax return without any error:

Run the Exec sp_changedbowner 'sa' command on the SQL Server.
Run the AETaxconfigupdate.exe

To run Exec sp_changedbowner 'sa' on the SQL Server

Follow the menu path: Start > Programs > Microsoft SQL Server 20xx > SQL Server Management Studio.
In Connect to Server window, select Database Engine in the Server type and enter the Server name.
In Authentication, select SQL Server Authentication.
Type sa in the Login field, then type the password. For the default password call MYOB Support or if you've changed the password from MYOB default, contact your IT person.
Click Connect.
Right click Tax database (eg AETAX1) > select New query.
In the query window on the right, enter the command: Exec sp_changedbowner 'sa'
To execute the command, select
or press F5 on the keyboard.

To run AETaxconfigupdate.exe

Before you begin, you'll need to know the location of your Bin folder. See Locating the bin folder.

Open Windows Explorer or computer, browse to the Bin folder and double-click the AETaxconfigupdate.exe file.
During this process, you'll see:
1. The services are stopped,
2. Tax components are configured,
3. Administration centre files are updated and the 12 steps of configuring the AE Tax database run.
When finished, the Setup Complete window appears.
Click Finish. The AETaxconfigupdate is completed

MYOB INTERNAL STAFF ONLY

You can also fix this error by running the script in SQL Management Studio.

Run this query only if you see the following in the error log:

System Release DAL SQL error 6522: [Microsoft][ODBC SQL Server Driver][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 informa[]

Make sure there is a backup before running the script.

This script must be run against both TAX and PM database. (If you are not sure how to run a query, please refer to the Cavalry team)

ALTER ASSEMBLY [system.messaging] FROM 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\system.messaging.dll'