Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
funk.phenomena
Posting Yak Master
121 Posts |
Posted - 2011-11-22 : 17:15:14
|
Hi all - I'm using 2008 SSRS. I can view the reports that I've created via the web link, without any issues.When other users try to access the same link, they keep on getting the error message below. I've even set them up as public users on the server. Any ideas?Thanks in advance!An error occurred during client rendering.An error has occurred during report processing.Query execution failed for dataset 'FTarget'.For more information about this error navigate to the report server on the local server machine, or enable remote errors |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-22 : 23:48:40
|
you need to map them to report role in report server like report browser.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
funk.phenomena
Posting Yak Master
121 Posts |
Posted - 2011-11-23 : 12:01:50
|
Hi Visakh - Thanks for your prompt response!Can you elaborate just a little bit further?Thanks!!! |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-11-23 : 14:38:16
|
I'm assuming it's a permissions problem but did you check the log files? They might offer a clue as to where you've missed something. Remember that every folder/level in SSRS can have its own permissions, so there's Home and the Reports folder, etc., depending on how you've set it up. |
|
|
funk.phenomena
Posting Yak Master
121 Posts |
Posted - 2011-11-23 : 17:26:19
|
Below is part of the log file.I've checked that this user is part of the "Browser" Role for both the reporting folder, and the Home Folder.Any other ideas?Thanks again !ReportServer_0-4!be0!11/22/2011-09:42:06:: w WARN: Rolling back shared chunk transaction for snapshot '9812672c-405e-4323-841b-b7853315db87', Permanent=False.library!ReportServer_0-4!be0!11/22/2011-09:42:06:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ELC'. ---> System.Data.SqlClient.SqlException: Login failed for user 'RCI\John.Doe'.webserver!ReportServer_0-4!be0!11/22/2011-09:42:06:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ELC'. ---> System.Data.SqlClient.SqlException: Login failed for user 'RCI\John.Doe'. |
|
|
|
|
|