Featured Post

Dynamics GP 2018 is now Released

It is officially published that Microsoft Dynamics GP 2018 is available, the download link is provided below: Product download page ...

Friday, June 19, 2015

Analytical Accounting Distribution Query Wizard "Login Failed for User" - Resolved with GP 2015 R2

We have witnessed an issue with the analytical accounting module when using the "Distribution Query Wizard", apparently this inquiry works only for the "sa" user and it gives a login failed error for any other user, including DYNSA or even a user with database sys admin role. Pretty interesting isn't it ?

You configure the distribution query wizard going through the steps to create a dynamic analytical accounting report with the "sa" user. The query can be tested and exported perfectly without a single issue. 
Once trying to either create a new query or execute an existing one with any other user than the "sa", the query maintenance crashes while processing and gives the following error.

Query Maintenance Wizard Processing - Error  

  "Unhandled object exception:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'xxx'.


"Unhandled object exception:
Operation is not allowed when the object is closed.


I have tested the exact same case on both GP 2015 RTM (14.00.0524) and March Hotfix (14.00.0061) with the same login failed error.

The resolution has seen the light with the release of GP 2015 R2 (14.00.0724) , it is mentioned in the product customer source, Service Pack, Hotfix, and Compliance Update Patch Releases forMicrosoft Dynamics GP 2015 

Dynamics GP 2015 Fix List - Analytical Accounting

Best Regards, 
Mahmoud M. AlSaadi

1 comment:

  1. Unfortunately, I am getting this message on 14.00.0898.