CRM could not generate report after database server restarted RRS feed

  • Question

  • Hi All,

    I have CRM 4.0 application with rollup 13 installed and separated database server. Before we restart database server, user still could generate the report using CRM connector configuration. But after we restart the server, all user could not generate the report.

    When I run the report directly from report server manager (SRS), SRS prompt me to fill Log in name and password. As far as I know this thing should happen when the report use CRM connection string.

    Is there any solution to fix this? also what the risks if I reinstall CRM connector?
    Thursday, December 23, 2010 1:59 AM

All replies

  • What's the error you're getting? 401 unauthorized?

    Try re-installing the SRS Connector and it's update

    Kids don't try this at home!
    Thursday, December 23, 2010 2:50 AM
  • this is the error i got from event viewer:

    Web service request SetDataSourceCredentials to Report Server http://database:9000/ReportServer2005 failed with SoapException. Error: An error has occurred during report processing. (rsProcessingAborted)

    Thursday, December 23, 2010 3:32 AM