Link to home
Start Free TrialLog in
Avatar of tommym121
tommym121Flag for Canada

asked on

SQL - Fail to preview report in Report Builder 3.

I try to preview a report in Report Builder 3 , but fail.  Here is the detail of the error:

System.Web.Services.Protocols.SoapException: The permissions granted to user 'Computer1\user1' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'Computer1\user1' are insufficient for performing this operation.
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)
----------------------------
The permissions granted to user 'Computer1\user1' are insufficient for performing this operation.
Computer1\user1 able to login to SSMS
Computer1\user1 able to read the database
Computer1\user1
Avatar of DcpKing
DcpKing
Flag of United States of America image

Are you pulling your data from a Stored Procedure, by any chance? Check that the ID that the report is running as does actually have rights to run SPs.

hth


Mike
Avatar of tommym121

ASKER

I am learning and running an example using SELECT

I notice that I have same error when I browse either to
http://Computer1:80/ReportServer1_SQLEnterprise
or
http://Computer1:80/Report1_SQLEnterprise
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks