Solved

Reinstalling a named instance of Dynamics CRM SSRS Data Connector

Posted on 2016-07-20
6
53 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:IT-NYC
Comment Utility
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 earned 500 total points
Comment Utility
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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

744 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

12 Experts available now in Live!

Get 1:1 Help Now