Sunday, May 13, 2012

The Microsoft Dynamics CRM Reporting Extensions Setup does the following

while installing MS CRM Reporting Extension what is does when we installed it...
The Microsoft Dynamics CRM Reporting Extensions Setup does the following:


1.     Installs Fetch and SQL data processing extensions on the Microsoft SQL Server Reporting Services server.

2.     Installs custom assemblies used by default reports and wizard reports on Microsoft SQL Server Reporting Services server.

3.     Creates default reports (SQL-based) for the default organization both on Microsoft Dynamics CRM Server 2011 and Microsoft SQL Server Reporting Services server.

The following table explains what reporting options will be available to you if you install Microsoft Dynamics CRM Reporting Extensions.

Installed?
What reports will work?
Default reports
Custom SQL-based reports
Fetch-based Wizard reports
Custom Fetch-based reports
No
Clean installation:
Will not be available.
§ Cannot be scheduled.
§ Can be uploaded and run if  Microsoft Dynamics CRM Server 2011 and SQL Server are installed on one computer or Trust for Delegation is configured.
Will not be available.
Cannot be uploaded and run.
Yes

Will be published for the default organization.
Can be uploaded and run.
Can be created, run, and scheduled.
Can be uploaded, run, and scheduled.

Important

Microsoft Dynamics CRM Reporting Extensions should not be installed on an instance of Microsoft SQL Server Reporting Services that is running under an account that is a member of the SQL Access Group. This can occur when Microsoft SQL Server Reporting Services is running under the same account as a Microsoft Dynamics CRM Server 2011 component. This configuration can make the system vulnerable to certain attacks. During installation, Setup detects this scenario. You can click Help for information about how to work around the issue.

Note that when you install Microsoft Dynamics CRM Reporting Extensions, you have the option of installing the component on a different server that is running Reporting Services. Therefore, by isolating Microsoft Dynamics CRM Reporting Extensions on a separate instance of SQL Server, which does not store the Microsoft Dynamics CRM databases, report performance may be improved.

thanks,
yes.sudhanshu

5 comments:

  1. yes..it detects that the user account that is running the reporting services is also installing the Reporting extensions and then it does not proceeds ahead. But you can work around this by changing the reporting services logon temporarily to a local account. Restart the service. Then install the Reporting extension and then again change it back. Again restart the service. You have clear up the encryption keys also while changing the logon. Sometimes when u are doing a corporate installation all you get is a single service account for all purposes.

    And the Authoring extensions requires Business Intelligence studio to be installed before it can proceed.

    ReplyDelete
  2. Microsoft Dynamics CRM online training will help you manage and prioritize your business goals, customize.we teach MS Dynamics CRM online training and class available at Hyderabad.
    Microsoft Dynamics CRM online training
    Microsoft Dynamics CRM training in Hyderabad

    ReplyDelete
  3. Arrowsol Training offers on online Learning courses and manuals are optimized to help you and your team gain in-depth knowledge of your deployment
    Microsoft Dynamics Training | Microsoft Dynamics online Training | Microsoft Dynamics Training online

    ReplyDelete
  4. I am satisfied that you simply shared this useful information with us.
    Please stay us informed like this. Thanks for sharing.
    Microsoft Dynamics CRM Online Training

    ReplyDelete
  5. Thanks for sharing a nice Information.....
    Best Microsoft Dynamics CRM - Top Microsoft Gold Partner Hyd
    Office 365, Azure Cloud, Microsoft Dynamics CRM Ready To Use for Mfg, Services
    Microsoft Dynamic CRM In Hyderabad

    ReplyDelete