Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Microsoft Dynamics CRM 2011 Reporting Extensions (using an XML configuration file) do NOT install RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hello,

     

    I installed MS CRM 2011 with the CRM-Databases being on a named instance of another server (serv4000\D4000) than the SSRS (Serv1111).

     

    The CRM installation ran through after all.

    Both of these URLs on my SQL Server Report Server work:

    http://serv1111/Reports/Pages/Folder.aspx

    è underneath the grey bar it does recognize the CRM database which is listed by name (and behind it it says !NEU (meaning new).

     

    http://serv1111/ReportServer

    è here to it does list
    Date <dir> CRMORGANIZATIONNAME_MSCRM

    Date <dir> SharedReports

     

    This is my config.xml file for installing the Microsoft Dynamics CRM Reporting Extensions (since I have to use this with a named Instance and having set Autogroupmanagmentoff to true):

    <crmsetup>
    <srsdataconnector>
    <configdbserver>SERV4000\D4000</configdbserver> 
    <patch update="false" />
    <AutoGroupManagementOff>true</AutoGroupManagementOff>
    </srsdataconnector>
    </crmsetup>

     

    However, I cannot install the CRM Reporting Extensions.

    Here are the warnings and the error in the log file:

    (Please look for Warning or Error in the second column after the time) 

    12:55:26|Verbose| Retrieving Base Language Id Provider=SQLOLEDB;Data Source=Serv4000\D4000;Initial Catalog= CRMORGANIZATIONNAME_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    12:55:26|   Info| Base Language Id of CRMORGANIZATIONNAME_MSCRM: 1033.
    12:55:26|Warning| Could not find a local RS instance corresponding to the reporting url http://serv1111/reportserver for organization CRMORGANIZATIONNAME
    12:55:26|   Info| CrmAction execution time; CollectAction; 00:00:01.4335020
    12:55:26|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace 
    12:55:26|   Info| Escaped Instance Name is RS_MSSQLSERVER
    …
    12:55:27|   Info| Check ConfigDatabaseExistsValidator: Success
    12:55:27|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=SERV4000\D4000;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    12:55:27|   Info| Config database version: 5.0.9688.583.
    12:55:27|   Info| Check ConfigurationDatabaseVersionValidator: Success
    12:55:27|   Info| Check PrivReportingGroupActiveDirectoryRightsValidator: Success
    12:55:27|   Info| Check CrmSqlDomainValidator: Success
    12:55:27|Warning| Check ReportServerInstanceValidator : Warning: Reports will not be published for some organizations because the Report Server instances used by these organizations differ from the instance selected during Microsoft Dynamics CRM Reporting Extensions Setup.
    12:55:27|   Info| Check CanPublishReportsValidator: Success
    12:55:27|   Info| Group Environment Checks
    12:55:27|  Error| Check ReportServerValidator : Failure: Setup requires SQL Server Reporting Services 2008 Service Pack 1 or later to exist at the specified Reporting Services Report Server SERV1111.
    12:55:27|   Info| Group User Input Checks
    12:55:27|   Info| Check TargetFolderValidator: Success
    12:55:27|Verbose| Validation ran.
    12:55:27|Verbose| Validation completed.
    12:55:27|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    12:55:27|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    12:55:27|   Info| Microsoft Dynamics CRM Reporting Extensions failed.
    12:55:27|   Info| Microsoft Dynamics CRM Reporting Extensions Setup did not complete successfully. At least one environmental check has reported an error. Check the log file for more information.
    12:55:27|  Error| Setup did not complete successfully.

     

    Would somebody have an idea what could be wrong?

    Thank you, I appreciate it.

    Andreas

     


    Thursday, April 14, 2011 12:23 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

     

    Please see this link: http://xrmadventures.wordpress.com/2011/04/04/crm-2011-reporting-extension-installation-with-pre-created-ad-groups/

    Thursday, April 14, 2011 6:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    Where are you installing the Reporting Extensions? this needs to be installed on the SSRS. It will automatically select the SSRS instance.

    you can only have one instance of the Reporting Extensions, corresponding to one MS CRM installation installed on a Reporting Server.

    Thanks and Regards

    AniMandal

    http://xrmadventures.wordpress.com/

    Thursday, April 14, 2011 8:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    well I described the scenario exactly.
    The errors stem from the fact that the CRM database itself is on a named instance of another MS SQL Server 2008.

    And I did install (or try to) on the SSRS Server. This leads to all the problems as mentioned in my first post.

    Any other ideas? Somebody?

    Thank you

    Andreas

    Friday, April 15, 2011 2:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi AndiMzD,

    If you are moving CRM 4.0 DB to a new instance of SQL Server for CRM 2011 then you will have to perform few registry key settings as well for successfully upgrade. Are you upgrading from CRM 4.0 to CRM 2011 and did you perform those registry settings if that is the case?

     

     

    Regards, Imran Abbasi
    Friday, April 15, 2011 10:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    this is a new installation, not an upgrade.

    The reporting extensions do not install with the CRM-Databases being on a named instance of another SQL Server 2008.

    Any other ideas?

    Thank you.

    Andreas

    Monday, April 18, 2011 7:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Andi,

     

    Try this

    http://support.microsoft.com/kb/947060

     

    And Make sure that you have selected the same reporting server URL when creating the New Organization

    Deployment Manager-> Organizations-> double click and confirm the URL.

     

    Can you please confirm which version of SQL Server did you installed?

     

     

    regards,

     

    Khaja Mohiddin

    Monday, April 18, 2011 11:38 AM