Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Tuesday, February 18, 2014

Error: No connection could be made because the target machine actively refused it 127.0.0.1:2383 for Dynamic AX 2012

Hi,

This error will arise in many different cases.
1. Some time it thrown when you open any reports in Dynamic AX 2012
2. Some time it thrown when opening only retail reports in Dynamic AX 2012
3. While connecting to the SSAS from SSMS
Solution:
Start the following services
·         Sql Server Analysis Services
·         Sql Server Agent
·         Sql Server
·         Sql Server Browser
·         Note: Please check “ Sql Server Analysis Services “  Status once you start remaining service may impact on stopping this service.

Regards,




Monday, February 17, 2014

Request for the permission of type 'SqlStatementExecutePermission' failed in Dynamic AX 2012

Hi,

sometimes running a Job in AX will cause above error.

Request for the permission of type 'SqlStatementExecutePermission' failed.
(S)\Classes\SqlStatementExecutePermission\demand
(S)\Classes\Statement\executeQuery
(C)\Jobs\test - line 21


Solution:
                     Run this job on Server.
How to run in server:
                     Create a menu item of type action, give the object type as Job ,and object name , and set the property Run on as" Server ".

Enjoy,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...