Insufficient Permission

Question

User1979860870 posted

Hi

 While deploying report - The permissions granted to user 'XYZ' are insufficient for performing this operation. 0 0

Thanks

Answer 1

User475983607 posted

While deploying report - The permissions granted to user 'XYZ' are insufficient for performing this operation.

Grant the user access.  This is typically done in the through the web interface.  The official Reporting Services documentation cover the basics but it does require a basic understanding of Windows security

https://docs.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-ver15

Answer 2

User1535942433 posted

Hi jagjit saini,

According to your description,it's because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder.

You could do like this:

1.Start Internet Explorer using "Run as Administrator"

2.Open http://localhost/reports

3.Go to properties tab (SSRS 2008)

4.Security->New Role Assignment

5.Add DOMAIN/USERNAME or DOMAIN/USERGROUP

6.Check Report builder

Best regards,

Yijing Sun