locked
Default reports cannot be published RRS feed

  • Question

  • We've installed Dynamics CRM 2013 using an AD based account (to follow the principle of least privilege). The application components of CRM have installed without issue, however the Reporting Extensions installation is indicating that 'Default reports cannot be published to one or more organizations because you do not have sufficient privileges'.

    We're executing "SetupSrsDataConnecter.exe" as “Admin” having logged into the SSRS server using the CRM install account. The CRM install account has SysAdmin access to the relevant SQL Server instance, and is DBO for the configuration and organisation databases. The CRM account also has full delegation for the OU being used for the CRM security groups.

    We attempted to install the Reporting Extensions using a domain admin account, however were presented with the same warning message. Ultimately we continued with the installation and reporting extensions installed successfully, however none of the default CRM reports are available.

    Does anyone have any ideas of what we've missed? Is it possible to install the default CRM reports outside of the Reporting Extensions installation?

    Many thanks for your help.

    Wednesday, May 14, 2014 2:46 AM

Answers

  • We figured out what the issue was. Our original installation had used a DNS alias for the database server. Evidently the Reporting Extensions installer had some issues with this when it came to installing the default reports.

    We resolved the issue by uninstalling Reporting Extensions on the database server, and rolling back the application server to a clean state (reverted the VM to a previous snapshot). We then re-installed Dynamics without using the database server alias. After completing the re-installation, Reporting Extensions (and the default reports) installed as expected.
    • Marked as answer by Nksoz Friday, May 23, 2014 6:31 AM
    • Edited by Nksoz Friday, May 23, 2014 6:32 AM
    Friday, May 23, 2014 6:30 AM

All replies

  • Does the account also have Administrator privileges in Reporting Services ?

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

    Wednesday, May 14, 2014 3:33 PM
    Moderator
  • Hi David,

    Thanks for you reply. The CRM install account has System Administrator permission at the site level, and Content Manager permission for the Home, SharedReports, and organisation folders.

    We've tried giving the account the full spectrum of permissions in SSRS without any success. I'm wondering if there's something about the way SSRS has been installed it doesn't like?

    Cheers

    Wednesday, May 14, 2014 11:10 PM
  • We figured out what the issue was. Our original installation had used a DNS alias for the database server. Evidently the Reporting Extensions installer had some issues with this when it came to installing the default reports.

    We resolved the issue by uninstalling Reporting Extensions on the database server, and rolling back the application server to a clean state (reverted the VM to a previous snapshot). We then re-installed Dynamics without using the database server alias. After completing the re-installation, Reporting Extensions (and the default reports) installed as expected.
    • Marked as answer by Nksoz Friday, May 23, 2014 6:31 AM
    • Edited by Nksoz Friday, May 23, 2014 6:32 AM
    Friday, May 23, 2014 6:30 AM