ya it's a 32 bit instance.

I have also enabled AWE from 0 to 1

After disabling AWE the query is working fine now...

Thanks for ur reply.

I have changed the time of job to run let's see what happen...

Thanks for your reply.

which objects property r u talking about (The Job?) can u tell me in detail?

thanks

please suggest me what are the necesary steps to do to avoid such issues?

thanks

rahul

Now it's working from another users credentials, the user has admin rights.

Thanks for Your reply.

HI,

I AM USING THE CURRENT USERS CREDENTIALS OPTION IN DATA SOURCE.

THANKS

RAHUL SINGH

Hi,

This security documentation realy resolved my issue.I have successfully configured SSRS security.

Now the user has rights to access report server database.

Thanks very much for ur reply.:-)

Thanks for ur reply...

but i am new on ssrs, please tell me how to give permission to that user?

thanks

rahul singh