CRM 2011 Reporting Extension Installation with pre-created AD groups

Microsoft CRM 2011 Reporting Extensions Installation with pre-created AD Groups

Software components required:

Microsoft CRM Server installation: CRM2011-Server-ENU-amd64.exe

As seen in the last post, we have successfully installed Microsoft Dynamics CRM2011. Then you have browsed to the Dynamics CRM URL and everything seems to work just fine – until you click on Reports in the My Workplace area. There are no reports! No out of box reports! If you try, you may be able to use the report wizard to create new report or even import a few in, but you will be unable to execute them. To get around the issue of complex SPN setups to work around Kerberos and double hops for making SSRS work, Microsoft has simplified (in a way) by requiring to install the CRM2011 Reporting Extensions on the Reporting Server. This post deals with the installation of the Reporting Extensions for CRM2011.

Continuing with the theme of our last post, we will install Reporting Extensions for CRM2011 in a corporate environment with pre-created active directory groups. To start the installation, extract the installation files from the Microsoft Server Installation package (CRM2011-Server-ENU-amd64.exe). Locate the folder where the files are extracted and look for the folder “SrsDataConnector”. Open this folder and locate the file “SetupSrsDataConnector.exe”. But we need to execute this file from the command prompt and give the Reporting Extension XML file as an input.

The XML file:

<crmsetup>

<srsdataconnector>

<configdbserver />

<autogroupmanagementoff>true</autogroupmanagementoff>

</srsdataconnector>

</crmsetup>

The key word here is autogroupmanagementoff set to true. Without this, Reporting Extension installation will give an error regarding active directory permissions.

Before we begin with the actual installation, keep the following points in mind:

  • The Reporting Extensions for CRM2011 must be installed on the SSRS server
  • The Reporting Server must be added to the PrivReportingGroup Active Directory
  • The installing user must be a local Admin on the Reporting Server

 

Enter the following command in the command prompt:

D:\install\CRM2011Setup\ SrsDataConnector >SetupSrsDataConnector.exe /config d:\install\ssrsinstall.xml

This assumes that I have extracted my files in the ‘CRM2011Setup’ folder under the ‘install’ folder on the ‘D:’ drive of my App server – replace as appropriate. The setup file for Reporitng extension will be in the folder “SrsDataConnector ” in the extracted folder. This also assumes that I am passing a config.xml file stored in the ‘install’ folder on the ‘D:’ drive of the app server. The contents of the xml file is already mentioned above.

SSRS Data Connector Installation step by step:

Check for updates and click Next:

Accept the License Agreement and click “I Accept”:

Enter the SQL server for the Microsoft CRM 2011 Database and click Next:

Enter the SSRS instance name and click Next. Important: You cannot type in the SSRS instance name. This is fetched automatically and hence has to be installed on the SSRS server.

Click Next:

Choose an installation location and click Next:

The system checks all need to be green. Warning are OK, but red errors must be fixed before proceesing. Click Next:

Click Next:

Click Next:

Reporting Extensions getting installed.

Congratulations, Reporting Extensions for CRM2011 installed.

Browse to the Reports section in the My Workplace and all the out of box reports will be there and now you should also be able to execute them.

There is however one shortcoming of the Reporting Extension. Only one copy of the Reporting Extension can be installed on the Reporting server, which limits the Reporting Server to serve only one Microsoft CRM instance. You can however have as many organizations as you want in that instance and reports will work in all of them.

AniMandal

Find me on Microsoft Forum: http://social.microsoft.com/profile/animandal/

Find me on LinkedIn: http://www.linkedin.com/in/animandal

About these ads
This entry was posted in CRM2011. Bookmark the permalink.

10 Responses to CRM 2011 Reporting Extension Installation with pre-created AD groups

  1. Andreas Meyer says:

    Hi,
    There is no setupserver in the directory SRSDataConnector. The setupserver is only for the installation of CRM itself, not for the Reporting Services. Most likely you meant to use the SetupSrsDataConnector.exe.
    However the problems really start when using a CRM database on a different server than where the SSRS database is.
    An example for that scenario would be helpful.
    Sincerely
    Andreas

    • animandal says:

      Hi Andreas

      You are right. Thanks for catching it. I have updated the blog.

      I would be shortly installing CRM for the scenario you have mentioned – where the SSRS data base is on a separate server from the MSCRM SQL DB. I will post the installation process for that too.

      Thanks and Regards
      AniMandal

  2. Can CRM 2011 Reporting Extension be installed on a SQL 2008 server with multiple SSRS instances?

    • animandal says:

      Hi Gary
      CRM 2011 Reporting Services Extension needs to be installed on the SQL Server Reporting Services Server. You can connect to the named instances of SQL server.

      The issue comes, if your SSRS happens to be installed on the SQL Server, then only one instance of the Reporting Services Extension can be installed on the server, which can point to only one instance of the SQL server. If you have multiple SSRS servers, you can then connect to multiple instances of SQL Server. Reporting Services Extension does not have multiple instance – just one instance per server (physical or virtual), hence the issue.

      Thanks and Regards
      AniMandal

  3. AniMandal, Thanks for the quick reply. Gary

  4. crm software says:

    Wow, awesome blog structure! How lengthy have you ever been blogging for? you made running a blog look easy. The total glance of your web site is great, as smartly as the content!

  5. Samy says:

    Hi,
    I run the installation as you explained first time it gave an Error the finish the installation
    I tried to install it again it asked me to Uninstall the Reporting Extension I did , then I Run the installation once again it worked with no problem, Now i default report doesn’t show up & when i try to make a custom report IE gave me an Error “An error has occurred during report processing. (rsProcessingAborted”
    Evemt Viewer “Error: An error has occurred during report processing. (rsProcessingAborted)”
    Any solution:
    Thanks

    • animandal says:

      Hi

      There can be a few things that can go wrong. Try the following
      - Check the service account for the Reporting Server and make sure it is added to the PrivReportingGroup group in active directory
      - Go to Deployment manager and change the reporting server for the organization – this will re-create the association between MS CRM and the Reporting Server
      - Re-install the reporting extension

      rsProcessingAborted usually appears when there is an access issue.

      Thanks and Regards
      - Ani

  6. Samy says:

    Hi Ani,
    Thank You very much for your replay
    Yes you were right it’s an access issue first I used network service account to get sure, the out of the report did not show up but the new report started to work. then i started to eliminate service accounts one by one till I got sure it’s Application Pool Service account . Now it works
    Thanks again
    Samy

  7. Pingback: SharePoint from Scratch » Dynamics CRM and its Reporting Services Extensions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s