Link to home
Start Free TrialLog in
Avatar of MartinPetersen
MartinPetersen

asked on

How to install CRM Data Connector for SQL Server Reporting Service on multiple reporting instances?

Hi
I tried to install a the SRSS on a SQL Server 2005 with Reporting Service. The Default instance is working, but i need to install SRSS also for a Instance SQL01\INSTANCE1

I used this command:
SetupSrsDataConnector /CONFIG c:\srsdataconnector\install-config.xml

Contents of install-config.xml:
<crmsetup>
  <srsdataconnector>
    <configdbserver></configdbserver>
    <autoupdateconfigdb>1</autoupdateconfigdb>
<reportserverurl>http://sql01/Reportserver$instance1</reportserverurl>
    <autogroupmanagementoff>0</autogroupmanagementoff>
    <instancename>instance1</instancename>
    <configsku>OnPremise</configsku>
    <!-- Set enabled = true for DB webstore integration.  Set configdb="true" for config db webstore integration-->
    <webstore enabled="false" configdb="false" />
    <monitoring>
<!-- Monitoring service account name and password. It can not be local system or network service account -->
      <serviceaccountname></serviceaccountname>
      <serviceaccountpassword></serviceaccountpassword>
    </monitoring>
  </srsdataconnector>
</crmsetup>


I am unsure about what must be typed in the configDB field and which service account has to be used. Has someone tried that before and can paste me a sample config of that?

When i try to install as above i get a error message: OpenRegKey(SOFTWARE\Microsoft\MSCRM failed.

Thanks in advance for your help.

Martin
SOLUTION
Avatar of St3veMax
St3veMax
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MartinPetersen
MartinPetersen

ASKER

Found solution as described