Report server configuration

Apr 28, 2010 at 4:29 PM
  • I went through the configuration steps in the installation document and successfully uploaded the reports to my SQL 2008 SP1 report server.  But whenever I try to run a report I receive the following error:

    An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'PolicyDW'. (rsErrorOpeningConnection)
    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  • What am I missing?  Is it a report server configuration error, or a error in the datasource configuration.

  • Any assistance would be greatly appreciated.


  • Coordinator
    Apr 29, 2010 at 3:48 AM

    Did you change the connection string in the Reporting Services data source named PolicyDW to point to the database you created/used to store the policy history? 

    Apr 29, 2010 at 9:01 PM

    Yes. in bids I changed the datas ource and successfully tested.  I am thinking it is a problem with the reporting services instance itself.  I am going to setup another one and point to that instead and see if I have different results.

    May 15, 2010 at 3:07 AM

    Hello SQLLawman,  Were you able to get the reports to work?