SSRS Reports are not being shown in mscrm 2011 RRS feed

  • Question

  • Dear all;

    i have reporting services running for mscrm 2011 on premises. the default reports of mscrm 2011 are being shown in mscrm but when i run the reports i got the following error.

    • Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
      • Immediate caller NT AUTHORITY\NETWORK SERVICE has insufficient privilege to run report as user

    i am using netwrok service account to run the reporting services and that account has full rights on all databases of crm and reporting i dont know what to do here

    • Edited by anwar_addi Monday, September 2, 2013 6:32 PM
    Monday, September 2, 2013 6:27 PM

All replies

  • Hi,

    The Network Service account should have publisher role for CRM. Please refer to this support article.

    Hope this helps!

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    • Proposed as answer by Mamatha Swamy Tuesday, September 3, 2013 2:30 AM
    Tuesday, September 3, 2013 2:28 AM
  • that solution is not working either.
    Tuesday, September 3, 2013 1:09 PM