Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SSRS 2008 and CRM 401 Unauthorized RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    look at this link
    http://extremecrm.net/2009/03/17/microsoft-crm-40-ssrs-2008-integration/

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

    Curtis Spanburgh
    Wednesday, May 6, 2009 5:01 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks,

    Perhaps, I will uninstall the SSRS DataConnector, review the services accounts, and reinstall the SSRS DataConnector.
    Wednesday, May 6, 2009 11:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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