SSRS Report using Stored Procedure works fine in BIDS but do not run on the Report Server
Thank You both! Yes, I know that the error message is not much useful :(. And I do not have permissions to make EnableRemoteErrors true on the ReportServer Database. I think what Olaf helper has suggested must be causing the issue. I would work with the DBA to check the permissions for the Datasource account on the stored procedures and update the results here.Bharkavi
March 11th, 2011 7:18pm

Dear Bharkavi, nothing at all; always a pleasure to help as far as I can.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 9:34pm

Special Thanks To Olaf helper again! Bharkavi
March 11th, 2011 9:59pm

I have created a report in SSRS with four datasets and three of the datasets use stored procedures. I have executed and tested the stored procedures both on DB server and from the SSRS datasets. They work fine as expected. And I used the data to create the layout and I was able to successfully build and run the Report in BIDS and the report works as expected. When I uploaded the Report on the Report server and established data source connections and tried to view the report I am able to do the parameter selections but when I click on the View Report button, I get the following message. My ID has content Manager permissions on the Report Server and also I am an administrator on it: An error has occurred during report processing. Query execution failed for data set '<datasetname>'. For more information about this error navigate to the report server on the local server machine, or enable remote errors Bharkavi
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 10:01pm

Hello Bharkavi, The error message isn't any useful. I guess the credential of the datasource don't have the permission to execute the stored procedure; you may check this first.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing
March 11th, 2011 10:17pm

Did you check the three datasets are configured in Report Manager and also check after deployment whether all the datasoources are deployed into Report Manager. I presume that one out four datasets datasource is not deployed if they all different. Otherwise to get complete error info select * from dbo.ConfigurationInfo in ReportServer database and make true for EnableRemoteErrors.Nanda
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 10:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics