Solved

Reports not working in CRM 4.0 with SQL Server 2008 R2

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

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…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

705 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

21 Experts available now in Live!

Get 1:1 Help Now