January 7, 2012 at 11:42 pm
I have created a report in 2008 R2. This report has one input parameter. The values for the input parameter are coming in drop down and the values for which are coming from a dataset which is also embedded in the report.
This dataset is having is very simple query:
SELECT campaign_id, [campaign_name]
FROM [dbo].[csi_campaign]
Now this report is working fine in my development environment. The database is on another server.
But when i deploy this report in SSRS web version there i am getting the error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'ddCampaign'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
I am using the same database as used in development environment and Database server is local on this machine.
The dataset above (ddCampaign) is the name of the dataset which is used to bring the values in the drop down for the input parameter.
Please suggest.
January 9, 2012 at 1:11 am
What kind of authentification do you use for your database? You should execute ist locally on the server where your SSRS is installed to get a better error message, but I suspect it's in the connectivity.
Lars
January 9, 2012 at 5:07 am
The database server is on the same server where SSRS is configured.
TO open the SSRS: i am using machine administrator account
For Database connectivity, previously i was using user: sa
and now it is working. I don't know what have i changed as it was the same previously.
Thanks for Suggestion
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply