Subreport error when not administrator

[Gerald Toh]

I am currently using Telerik in WSS3.0. I have a main report with 3 sub reports in which the main report will pass the parameters to the sub reports to do the filtering on the respective sub reports.

I have tried testing using the administrator and everything works fine. The problem comes when I test it using a non administrator. The main report is fine but all the sub reports have error 'An error has occured while processing.....'.

Please advise as I have no idea on where to look for in this issue and I need to fix this urgently. Since administrator have no problem with the report.
I am using the version 2.9.8.1209

[Steve]

Hello Susan,

This seem like authentication problem in WSS and we do not believe there is much that we can do. It looks like you're accessing some resources that are only available through the admin user. You can open and review the application event log for the specific exception to get an idea what is causing the issue.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Eugene]

I found out that it is the sql security issue. thanks for the advise on which direction to look at and the hints