Wednesday, March 7, 2012

Reporting Services error after installing sql server 2005 sp2

Please help!

I have an asp.net 2.0 web app that integrates with reporting services. Since installing sql server 2005 sp2 I get the following error when trying to access reports:

  • 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)

    I've checked the directory security for the report server website in IIS and integrated windows authentication is checked.

    I can't understand what has caused the problem, before sp2 the reports were working fine.

    Thanks in advance for any help,

    Andy

    We have had the exact same issue in all of our environments - Dev, Staging and Production. Our only work around was to enable sql authentication and setup new datasources using a sql authenticated user. We'd certainly prefer to maintain only windows authentication on our sql servers but can not do so until this issue is resolved.
    |||

    I used this workaround as well. Also I receive the following error in the Sql server 2005 Surface Area Configuration tool when selecting the 'Windows Integrated Security' node under 'Reporting Services':

    The request failed with HTTP status 403: Forbidden. (SQLSAC)

    The check box to enable Windows integrated security is greyed out. Do you receive any such error?

  • No comments:

    Post a Comment