locked
Reports Error RRS feed

  • Question

  •  

    Hi 

     

       I am working on CRM Reports. When i am trying to access the reports it displaying reports in  Server  with  one service account. when i am accessing the reports from the cleint machine it is showing error message as  "error occured please contact system administrator"  for all the user incluing that service account.  Any idea how to solve this one

     

    the reports Image is displaying  in server with service account in sales lead and opportunities entities. the reports image is not displaying to other users eventhough the user have systemadministrator and system customizer roles

     

     

    Thanks

    Shaik

    Monday, April 28, 2008 3:47 PM

Answers

  •  

    Can you access the basic SRS reports at http://<servername>/Reports? If
    not, you have an SRS issue, not a CRM double hop authentication issue, and
    you will need to troubleshoot your SRS install.

    A good document to get is the RSSetupTfD.doc from Microsoft. It goes over
    additional steps needed for accessing SQL Reports. You can access it at
    http://www.microsoft.com/downloads/details.aspx?FamilyID=51bf9f20-bd00-4759-8378-b38eefda7b99&DisplayLang=en

    Sometimes just adding the following entries to the ServicePrincipleName for
    that machine under ADSIEDIT helps as well...

    HOST/<servername>
    HOST/<servername>.<domain>
    HTTP/<servername>
    HTTP/<servername>.<domain>

    However, please make sure they do not exist already. The RSSetupTfD.doc
    describes how to query for these in AD.

    Monday, May 5, 2008 1:21 PM
    Moderator