Sign in

Microsoft.com

Microsoft

Remove From My Forums

Reports not working in CRM 4.0 with SQL Server 2008 R2

Question
0

Sign in to vote

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).

Wednesday, September 8, 2010 5:32 PM

Answers

0

Sign in to vote
Can you run the report directly from the Report Server? Also, rather than applying UR 10, apply UR 12 to the server, data connector, etc. and reboot all servers associated with CRM

You can have a look at this post for additional troubleshooting options.

http://social.microsoft.com/Forums/en-US/crmdeployment/thread/1c0e9327-d915-4e00-aa2e-ac28ba498342

if the above does not help, check your application logs for errors and see if you can obtain more information. You can also turn on dev errors and see if you get a more detailed error message.

Regards, Donna
- Marked as answer by mihaisz Thursday, September 9, 2010 12:05 AM
Wednesday, September 8, 2010 6:14 PM

All replies

0

Sign in to vote

Did you try reinstalling the SSRS Data Connector?
Regards, Donna

Wednesday, September 8, 2010 5:39 PM
0

Sign in to vote
Yes I did this:

Uninstalled srsdataconnector
Reinstalled srsdataconnector
Re-applied Rollup 10
Wednesday, September 8, 2010 5:46 PM
0

Sign in to vote
Can you run the report directly from the Report Server? Also, rather than applying UR 10, apply UR 12 to the server, data connector, etc. and reboot all servers associated with CRM

You can have a look at this post for additional troubleshooting options.

http://social.microsoft.com/Forums/en-US/crmdeployment/thread/1c0e9327-d915-4e00-aa2e-ac28ba498342

if the above does not help, check your application logs for errors and see if you can obtain more information. You can also turn on dev errors and see if you get a more detailed error message.

Regards, Donna
- Marked as answer by mihaisz Thursday, September 9, 2010 12:05 AM
Wednesday, September 8, 2010 6:14 PM