Answered by:
Reports not working in CRM 4.0 with SQL Server 2008 R2

Question
-
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
-
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.
- Marked as answer by mihaisz Thursday, September 9, 2010 12:05 AM
Wednesday, September 8, 2010 6:14 PM
All replies
-
Wednesday, September 8, 2010 5:39 PM
-
Yes I did this:
- Uninstalled srsdataconnector
- Reinstalled srsdataconnector
- Re-applied Rollup 10
Wednesday, September 8, 2010 5:46 PM -
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.
- Marked as answer by mihaisz Thursday, September 9, 2010 12:05 AM
Wednesday, September 8, 2010 6:14 PM