[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Reports not working in CRM 4.0 with SQL Server 2008 R2

Posted on 2010-09-08
1
Medium Priority
?
757 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
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

830 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