Solved

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

Posted on 2009-06-27
3
1,122 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
crm 2010 on premise 5 75
Value Lookup 10 47
sql query help 2 51
SSRS Get Last Day of Year 2016 2 67
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

785 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