Reports not working in CRM 4.0 with SQL Server 2008 R2

[MSz]

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

[Fulanito]

Hi MSz,

Have you tried this?
Open the file MSCRM 4.0 on http://[YourServerReporName]/reports
Can you see any report in that file????

There's a tool PublishReports that publish all the reports (even customized
reports).
This tool is on the server application (by default is at C:\Program
Files\Microsoft CRM\Tools\PublishReports.exe)

The way that you have to use this tool is:
1.open a comand prompt in your server application and Place yourself in the
directory where the tool is located
2. then write: PublishReports [OrganizationName] (do not write the brackets)
I.E: C:\Program Files\Microsoft CRM\Tools>PublishReports MyOrganization
3. Press the ENTER key

try to open de report again

Post by MSz
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.
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).

[KM CHAN]

123456

"MSz" 在郵件張貼內容主旨 958F70AD-665E-4D79-ABDD-***@microsoft.com
中撰寫...

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