Solved

Reports not working in CRM 4.0 with SQL Server 2008 R2

Posted on 2010-09-08
1
747 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 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

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…
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.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

776 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