web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AX 2012 R2: Error while deploying reports.

(0) ShareShare
ReportReport
Posted on by 725

Hi Experts,

I have been trying to deploy the reports from AX and shell command. but i am getting Access denied error, following is the error.

Publish-AXReport : Access is denied. (Exception from HRESULT: 0x80070005

(E_ACCESSDENIED))

At line:1 char:1

+ Publish-AXReport -ReportName SalesConfirm* -skipReportServerAdminCheck

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   + CategoryInfo          : SecurityError: (:) [Publish-AXReport], Unauthori

  zedAccessException

   + FullyQualifiedErrorId : Access is denied. (Exception from HRESULT: 0x800

  70005 (E_ACCESSDENIED)),Microsoft.Dynamics.AX.Framework.Management.Reports

 .PublishReportCommand

Publish-AXReport : The deployment was cancelled because of an error. On the

report server, verify that:

- The SQL Server Reporting Services service is running.

- SQL Server Reporting Services is configured according to the instructions in

the Microsoft Dynamics AX Installation Guide

(go.microsoft.com/fwlink).

- The Remote Administration feature is allowed to communicate through Windows

Firewall.

At line:1 char:1

+ Publish-AXReport -ReportName SalesConfirm* -skipReportServerAdminCheck

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   + CategoryInfo          : ResourceUnavailable: (Microsoft.Dynam...ReportsD

  eployer:ReportsDeployer) [Publish-AXReport], ServerException

   + FullyQualifiedErrorId : The deployment was cancelled because of an error

  . On the report server, verify that:

- The SQL Server Reporting Services service is running.

   - SQL Server Reporting Services is configured according to the instruction

  s in the Microsoft Dynamics AX Installation Guide (http://go.microsoft.com

 /fwlink/?LinkID=163796).

   - The Remote Administration feature is allowed to communicate through Wind

  ows Firewall.,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishRe

 portCommand

I checked that i have permission on the reporting site. I can create/add report on the reporting server. But when i try to deploy the report from AX or shell command i get the error.

The remote registry service is running on the report server. I am also getting error when i press validate button on the report configuration setup. Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED)).

The administrator user can deploy the report, but with my credentials its throwing error.

Can any one help me on this urgently.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Xander Vink Profile Picture
    2,550 on at
    RE: AX 2012 R2: Error while deploying reports.

    Hi Zeeshan,

    is your account a member of the Administrators group on the server that is running SSRS?

    Regards,

    Xander

  • Syed Zeeshan Haider Jafry Profile Picture
    725 on at
    RE: AX 2012 R2: Error while deploying reports.

    No the account is not in Administrators group. But it should work as i have publish permission on SSRS report server.

  • Suggested answer
    Xander Vink Profile Picture
    2,550 on at
    RE: AX 2012 R2: Error while deploying reports.

    No, to publish the reports you need to be in the Administrator group of the server.

    It's a requirement:

    msdn.microsoft.com/.../dd309703.aspx

  • Syed Zeeshan Haider Jafry Profile Picture
    725 on at
    RE: AX 2012 R2: Error while deploying reports.

    I am not able to deploy the report from AX also. Will that also require to be an administrator.

    Regards,

  • Xander Vink Profile Picture
    2,550 on at
    RE: AX 2012 R2: Error while deploying reports.

    Yes. To deploy any report you need to be administrator.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans