none
How to resolve Permissions Granted to user '<UserName>' are insufficient for performing this operation

    Question

  • Hi All
    I am using SQL server 2005 Reporting Services & whenever i would like to deploy my rdl in my report server the following error message appear.

    The Permissions Granted to user '<UserName\Domain>' are insufficient for performing this operation.(rsAccessDenied)

    so how could i resolve this problem..
    Please help me out ..
    It's very urgent ...


    Thanks in advance...

    Tuesday, January 13, 2009 6:55 AM

Answers

  •  

    Hi,

     

    To deploy a report, you must have Publish permissions on the target folder to publish reports to that folder. Publish permissions are provided through a role assignment that maps your user account to a role that includes publish operations. More information, please see the following document.

     

    How to: Set Deployment Properties (Reporting Services)

    http://msdn.microsoft.com/en-us/library/ms155802.aspx

     

    Hope this helps.


    Garsy Liang - MSFT
    Thursday, January 15, 2009 8:28 AM

All replies

  • You should have Administrator Permissions for deploying reports.
    Rajesh Jonnalagadda http://www.ggktech.com
    Tuesday, January 13, 2009 7:56 AM
    Answerer
  •  

    Hi,

     

    To deploy a report, you must have Publish permissions on the target folder to publish reports to that folder. Publish permissions are provided through a role assignment that maps your user account to a role that includes publish operations. More information, please see the following document.

     

    How to: Set Deployment Properties (Reporting Services)

    http://msdn.microsoft.com/en-us/library/ms155802.aspx

     

    Hope this helps.


    Garsy Liang - MSFT
    Thursday, January 15, 2009 8:28 AM