Solved

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

Posted on 2009-06-27
3
1,100 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:MartinPetersen
  • 2
3 Comments
 
LVL 13

Assisted Solution

by:St3veMax
St3veMax earned 450 total points
Comment Utility
What happens if you use the Reporting Services Config gui ?
0
 

Accepted Solution

by:
MartinPetersen earned 0 total points
Comment Utility
Hi

I found the solution myself. It is NOT possible to install the CRM Connector to more than one Instance!
The solution was to install another SQL Server....
0
 

Author Comment

by:MartinPetersen
Comment Utility
Found solution as described
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now