none
CRM Dynamics 365 - after moving db server cannot run reports

    Question

  • After moving the database server and install server extensions on the new server, I receive the following errors when trying to run any SSRS report from within CRM. I can run the reports from the SSRS website.

    In the CRM server event log I see the following error. Web service request ListExtensions to Report Server http://trgdsql01/ReportServer/ReportService2010.asmx failed. Error: The request failed with HTTP status 401: Unauthorized.

    In the SSRS server event log I see the following error. 

    The description for Event ID 1314 from source ASP.NET 4.0.30319.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event: 

    4008
    File authorization failed for the request.
    04/19/2017 14:20:11
    04/19/2017 18:20:11
    0b768685a78940a7be0adf80f6d4fc51
    379
    7
    0
    ReportServer_MSSQLSERVER_0-1-131370963933956271
    RosettaSrv
    /ReportServer
    D:\SQL\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\
    TRGDSQL01
    1852
    ReportingServicesService.exe
    TRG\ProdService
    http://[db servername]/ReportServer/ReportService2010.asmx
    /ReportServer/ReportService2010.asmx

    TRG\[CRM servername]$
    True
    NTLM
    TRG\[crm servername]$

    The CRM server was unistalled and reinstall. The same error occurred before and after the reinstall.

    Any help will be greatly appreciated. 

    Wednesday, April 19, 2017 6:33 PM

All replies

  • There are two main possible causes:

    • SPNs. Check that the correct SPNs have been created for the CRM and Reporting Server. More information should be in the CRM Implementation Guide
    • Check that the CRM service account (the identity of the CRM App Pool), has permissions in Reporting Service

    Also, the reporting services log file may give more information


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, April 20, 2017 9:03 AM
    Moderator