May 27, 2010 at 2:46 pm
After referring to a posting in a wrong forum on this site and other places on the Internet, I have configured reporting services to use anonymous access for our web application. (yes I know, security risk, slap my hand). Anyway, after getting past some typos (others and my own), I believe I'm close to getting it working. The report window is appearing with the header, but I'm getting the following error:
* An error occurred during client rendering.
o An error has occurred during report processing. (rsProcessingAborted)
+ This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)
The rdl file source is configured currently for Windows Integrated Security. I have also tried setting up a limited local user on the windows server and assigning them to the source as well as creating a login for the SQL database, as well as trying no authentication and adding this user to reporting services configuration but these just seem to generate a different errors.
Any insights would be appreciated.
May 27, 2010 at 3:22 pm
amahanna (5/27/2010)
After referring to a posting in a wrong forum on this site and other places on the Internet, I have configured reporting services to use anonymous access for our web application. (yes I know, security risk, slap my hand). Anyway, after getting past some typos (others and my own), I believe I'm close to getting it working. The report window is appearing with the header, but I'm getting the following error:* An error occurred during client rendering.
o An error has occurred during report processing. (rsProcessingAborted)
+ This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)
The rdl file source is configured currently for Windows Integrated Security. I have also tried setting up a limited local user on the windows server and assigning them to the source as well as creating a login for the SQL database, as well as trying no authentication and adding this user to reporting services configuration but these just seem to generate a different errors.
Any insights would be appreciated.
Depend on the SQL Server version that you are using, remember that SQL Server Reporting Services use several technologies, and have several connections involved. The reporting services has an authentication on SQL Server database specific for ReportServer, the Report that you design and use has authetication for connect to User Database, so if You are using SQL Server Reporting Services 2005, then you need configure IIS to use connection, but if you are using Reporting Services 2008 you need configure the services differently.
So, you need review all components, connections involved and configure to accept the annonimus user.
Regards
May 28, 2010 at 5:16 am
Sorry. I thought since this was a SQL Server 2008 forum that I didn't need to give the specifics. It's SQL server 2008 Enterprise and Reporting Services. I've never had this probably with 2005, since there was no need to jury-rig anonymous access.
May 28, 2010 at 5:27 am
FYI, this is the posting that I referred to for configuring anonymous access is 2008.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply