?
Solved

Reports not working in CRM 4.0 with SQL Server 2008 R2

Posted on 2010-09-08
1
Medium Priority
?
753 Views
Last Modified: 2012-05-10
Rollup 7 adds support for SQL 2008 R2 (http://support.microsoft.com/kb/971782/) so I’ve upgraded my SQL 2008 to R2.
The problem is that the CRM reports are no longer working.

This article explains how to do the upgrade: http://social.microsoft.com/Forums/en-US/crmdeployment/thread/ff80e743-c921-45b4-b055-71b193bdc7f0, but it’s too late for me: I’ve already done the upgrade without uninstalling SQL SRS.

What is the easiest way to fix it now that SQL R2 is installed?
Is it something with repointing to the SQL R2 paths (I noticed that R2 changed the path for report server files).
0
Comment
Question by:mihaisz
[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
1 Comment
 
LVL 5

Accepted Solution

by:
David Christal CISSP earned 2000 total points
ID: 33629765
You shouldn't have to uninstall SSRS, just the data connector.  On the sql server go the the control panel / add-remove programs and uninstall Microsoft Dynamics CRM Data Connector for Microsoft Sql Server Reporting Services.  Then re-install it from your original CD, then reapply the rollup(s).
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

800 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