Query execution failed for data set...

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.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|||You nailed it dude. Thanks for that.
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
>