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\instal l-config.x ml
Contents of install-config.xml:
<crmsetup>
<srsdataconnector>
<configdbserver></configdb server>
<autoupdateconfigdb>1</aut oupdatecon figdb>
<reportserverurl>http://sql01/Reportserver$instance1</reports erverurl>
<autogroupmanagementoff>0< /autogroup management off>
<instancename>instance1</i nstancenam e>
<configsku>OnPremise</conf igsku>
<!-- 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></serv iceaccount name>
<serviceaccountpassword></ serviceacc ountpasswo rd>
</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\Micros oft\MSCRM failed.
Thanks in advance for your help.
Martin
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\instal
Contents of install-config.xml:
<crmsetup>
<srsdataconnector>
<configdbserver></configdb
<autoupdateconfigdb>1</aut
<reportserverurl>http://sql01/Reportserver$instance1</reports
<autogroupmanagementoff>0<
<instancename>instance1</i
<configsku>OnPremise</conf
<!-- 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></serv
<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\Micros
Thanks in advance for your help.
Martin
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER