Friday 16 August 2013

Report not deploying in AX2012 reporting server(The deployment was aborted. You do not have privileges to deploy to server:. For deployment, you must have administrative rights to the SQL Server Reporting Services (SSRS) server. Contact your administrator to deploy.)

Recently I faced one issue, I was trying to deploy the SSRS report, as soon as I select "Deploy Element" from AX.


Below is the error:

"The deployment was aborted. You do not have privileges to deploy to server: <server name>. For deployment, you must have administrative rights to the SQL Server Reporting Services (SSRS) server. Contact your administrator to deploy."

Then i found out the reason for this issue, you need to give the Administrator rights (in reporting server machine) to that user who is trying to deploy.

  1. Go in Computer management and then select "Local Group and Users".
  2. Now select "Groups". 
    
3.     Double click "Administrator" group and Add your user as shown below.



After doing these steps try depoying report again, the issue will be resolved.

Hope this helps!

2 comments:

  1. Hi ,

    You can use below query to over write the reports deployment issue. You can execute this query from MSDAX2012 Management shell

    Publish-axreport -reportname {Ex :custtranslist} –SkipReportServerAdminCheck

    Regards.,
    Ravi Theja Madisetty
    https://techguns.wordpress.com

    ReplyDelete
    Replies
    1. Thanks Ravi for above solution. It worked in my case.

      Delete