Solved

Reinstalling a named instance of Dynamics CRM SSRS Data Connector

Posted on 2016-07-20
6
76 Views
Last Modified: 2016-07-27
I need to repair (after change of service account and loosing encryption settings) one of the CRM Reporting named instances running of an SQL 2012 Server.
During the repair process, only one instance (alphabetically) is visible to SrsDataConnector, the one I don't want to change.
I read that the command line option is available but how to use it for repair?

SetupSrsDataConnector /Q /CONFIG folderpath\install-config.xml
Thanks in advance!
0
Comment
Question by:IT-NYC
  • 3
  • 3
6 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 41722277
I'm confused by your question, because I thought the SSRS Data Connector could only be installed once on a server and therefore only configured for one instance of SSRS.

The fact that your are only seeing one instance during repair is expected.
1
 

Author Comment

by:IT-NYC
ID: 41723471
After i posted the question, I discovered this in the MS document.
So, I went to another server and tried to install it fresh (there are 2 instances of SSRS but that is Ok, right?). Ran it as Reports account. Installed a new organization, it went smooth but I still cannot see the reports. The error is "Error occurred while fetching the data extension"
The reporting server URL is correct, I can browse all of the default reports. I granted the Reports account Sysadmin and publisher right inside of SSRS site but no luck.
I have a few questions.
1. Which account should be used to run SSRS service?
2. Which account should be used as service account inside of SSRS Configuration page?
The account has the rights to the databases (config, CRM, Reports).
Any advice is appreciated.
Thanks!
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 41724245
I'm not sure I've followed the sequence of events in your case but this is the usual procedure:
 
  1. Install SQL Server using a domain account (if not already installed)
  2. Install SSRS using a domain account (on the same server as SQL or a different server, it doesn't matter for CRM
  3. Install CRM Server - during the install you specify the SQL Server and SSRS server to use
  4. After CRM Server is installed, install Reporting Extensions on the server that was specified for SSRS during the install of CRM Server. If more than instance of SSRS is installed on the server, select the one that was used for CRM.

A regular domain account should be used for SQL and SSRS, CRM doesn't care what these accounts are. You should not need to assign any rights to databases manually. All of that is taken care of during the install of SQL, SSRS and CRM.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:IT-NYC
ID: 41729490
Ferdun,
Thanks for the information.
In my case, we are trying to use Reporting Services that are different from the original Reporting Services    Server, say, SQl2 instead of SQL1.
So, currently, there is a mix of several organizations. One of them points to SQl1, Two of them point to SQL2. The idea is to move it to SQL2 altogether.
Reports don't work in any of the organizations.
Is it possible that the cause of this is that, in the deployment guide, it says:
"Although, in a multiple organization deployment of Microsoft Dynamics CRM, you can specify different Reporting Services servers or server instances when you create or edit an organization, only one instance of Reporting Services is supported for all organizations in the deployment. "
And I have to move all of them before any other troubleshooting steps will take place?
Thanks.
0
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 41730764
Well I guess it is possible that is the reason.
I think I would backtrack and start again.
  1. By this I mean uninstall the CRM Reporting Extensions from all SQL Servers.
  2. Determine which SSRS instance you will use, sounds like SQL2 from your previous comment and make sure the SSRS isntance is working
  3. Then in CRM Deployment Manager, review the properties for each organization and ensure that the SQL Server Reporting Services URL is pointing to the correct (SQL2) SSRS instance.
  4. If it isn't, disable the organization, and then edit the organization to correct the SSRS URL, but don't change the SQL Server value - that is where the CRM database is stored. Enable the organization.
  5. Finally, install Reporting Extensions on the server running the SSRS instance.
If reports still don't work you might need to set Service Principal Names for some service accounts but that is another story. See if the above works first.
0
 

Author Comment

by:IT-NYC
ID: 41732127
I appreciate your effort. After moving all of the organizations SSRS settings to SQL2 (one org db and MSCONGIG db are still on SQL1), in one of the organizations, reports started to work!
Then, they stopped with Web service request GetParameters to Report Server failed. Error: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version.
I will close this question and open a new one in a few days.
Thanks.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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