SSRS 2008 and CRM 401 Unauthorized RRS feed

  • Question

  • Getting this in the event log of SQL 2008 Machine!
    Web service request SetParameters to Report Server http://server/ReportServer_APPS failed. Error: The request failed with HTTP status 401: Unauthorized.

    Reports are working only if i run them straight off the CRM machine, nowhere else...

    Please help

    Wednesday, May 6, 2009 12:31 AM


All replies

  • Hi,

    What's your Service Account in the Reporting  Service Configuration Manager?

    Make sure you are use "Network Service" or Domain User Account.

    Wednesday, May 6, 2009 1:32 AM
  • look at this link

    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Wednesday, May 6, 2009 3:30 AM
  • Sounds like a delegation error.  You have the SRS connector installed?

    Curtis Spanburgh
    Wednesday, May 6, 2009 5:01 AM
  • Thanks,

    Perhaps, I will uninstall the SSRS DataConnector, review the services accounts, and reinstall the SSRS DataConnector.
    Wednesday, May 6, 2009 11:55 AM
  • I did review this link before and it seems that they're starting from an upgrade path from SQL2005 to SQL2008 which we did not do.
    We are looking at a fresh install.

    Also, in this document, they talk about "Use embedded data-sources".

    Are you talking seriously?

    I would have to go through all the reports of CRM?

    Wednesday, May 6, 2009 11:59 AM