I am able to deploy and run reports from my screen at work, but some non-developers cannot run them. They can see the reports, but get the following error message when they click on the report:
Can you make sure that the users who are having issues can actually connect to the SQL Server & database?
Have you tried running Profiler to see what credentials are actually passed to the SQL Server when the user runs the report?
Jarret
|||What was found was a security issue. I got some DBA help in setting up permissions to login to the database and to grant run permissions on the queries. First access was granted to the database itself, the we had to go into security on the database and setup the user and grant permissions. This resolved the problem.
No comments:
Post a Comment