On Jul 20, 7:14 am, "Jarryd" <jar...@community.nospam> wrote:
> Hi,
>
> Query execution failed for data set<dataset name>
>
> Does anyone know why this error could be coming up? If I log in as a member
> of the Administrators group the report runs fine.If I run it as a user that
> I have given every permission to (Browser, Content Manager, etc.) I get the
> error.
>
> TIA,
>
> Jarryd.

"EMartinez" <emartinez.pr1@gmail.com> wrote in message
news:1184936231.667037.306150@22g2000hsm.googlegroups.com...
> On Jul 20, 7:14 am, "Jarryd" <jar...@community.nospam> wrote:
>> Hi,
>>
>> Query execution failed for data set<dataset name>
>>
>> Does anyone know why this error could be coming up? If I log in as a
>> member
>> of the Administrators group the report runs fine.If I run it as a user
>> that
>> I have given every permission to (Browser, Content Manager, etc.) I get
>> the
>> error.
>>
>> TIA,
>>
>> Jarryd.
>
>
> You will want to make sure that the default DB user account that the
> report is running under has execute permissions on the stored
> procedure in the dataset, if you're using one. If you're not using
> one, make sure that the default DB user account has select permissions
> on any tables used in the query. Note that DB user account/permissions
> are not the same as Report Manager/Windows user account/permissions.
> Hope this helps.
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant
>