?
Solved

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

Posted on 2009-06-27
3
Medium Priority
?
1,158 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 13

Assisted Solution

by:St3veMax
St3veMax earned 1800 total points
ID: 24785761
What happens if you use the Reporting Services Config gui ?
0
 

Accepted Solution

by:
MartinPetersen earned 0 total points
ID: 24830534
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
ID: 24830546
Found solution as described
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

752 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