locked
installing two srsDataConnectors on a single SQL Server machine. RRS feed

  • Question

  • hi guys, we have a CRM Server and a SQL Server with the SRSDataConnector of the CRM server installed.

    but now we have one more CRM Server and we created a instance of SQL Server on the SQL Server , but when installing the SRSDataconnector for the second crm server, the setup is asking to either repair or uninstall the srsdataconnector. How can we resolve this issue. As a temporary solution we have used the SRS url of the default instance while creating organisation. Can any one tell me the importance of srs url while creating the organisations.

    Thursday, April 25, 2013 7:53 AM

Answers

  • I don't think it's possible to install more than one instance of the srsDataConnector on the same SQL machine, even if you have separate RS instances. The following is from the CRM Implementation Guide:

    'You can install and run Microsoft Dynamics CRM Reporting Extensions on only one instance of Microsoft SQL Server Reporting Services on a computer'


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

    • Proposed as answer by VidhiyaM Thursday, April 25, 2013 10:35 AM
    • Marked as answer by SyedHaroon Friday, April 26, 2013 6:57 AM
    Thursday, April 25, 2013 10:22 AM
    Moderator

All replies

  • Hi,

    check the url http://mostlymscrm.blogspot.in/2012/09/creating-new-organization-in-dynamics.html which is the snapshot for creating organisation.

    While creating organisation,it will ask for sql server instance and reportserver url on which the organisation gets created. In the report server url,  a environment will be created for storing the reports.

    for reference,http://technet.microsoft.com/en-us/library/hh699772.aspx 


    Sindu M

    Thursday, April 25, 2013 9:38 AM
  • You will have to install the Connector using a Setup.xml file and define your instance in there.

    Carsten Groth http://carstengroth.wordpress.com Microsoft Dynamics Certified Technology Specialist, MVP für Microsoft Dynamics CRM

    Thursday, April 25, 2013 9:58 AM
  • I don't think it's possible to install more than one instance of the srsDataConnector on the same SQL machine, even if you have separate RS instances. The following is from the CRM Implementation Guide:

    'You can install and run Microsoft Dynamics CRM Reporting Extensions on only one instance of Microsoft SQL Server Reporting Services on a computer'


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

    • Proposed as answer by VidhiyaM Thursday, April 25, 2013 10:35 AM
    • Marked as answer by SyedHaroon Friday, April 26, 2013 6:57 AM
    Thursday, April 25, 2013 10:22 AM
    Moderator