locked
Upgrade SQL Server 2008 to SQL Server 2008 R2 RRS feed

  • Question

  • Hello, all.

    Help please. After upgrade  SQL Server 2008 to  SQL Server 2008 R2 all  reports in CRM doesn't work. 

    Wednesday, May 26, 2010 6:36 AM

Answers

  • Hi,

    have you installed at least Rollup 7 (it brings support for SQL 2008 R2)? Have you deployed the Reporting Services Connector?

    • Marked as answer by Elka_ Tuesday, June 1, 2010 1:10 PM
    Friday, May 28, 2010 7:49 PM

All replies

  • there is a utility in the directory where crm is installed c:/programfiles/ms dynamics crm/tools  this is just a guess on the actual location. but the file is labeled publishallreports.  you might be able to search on that for exact location. i'll post the actual file and location when i can get access.
    Withers *Check out my javascript working examples on my blog http://withersblog.withersdavid.com/
    Wednesday, May 26, 2010 2:11 PM
  • C:\Program Files\Microsoft Dynamics CRM\Tools\PublishReports.exe
    Withers *Check out my javascript working examples on my blog http://withersblog.withersdavid.com/
    Wednesday, May 26, 2010 4:41 PM
  • Thank you, but it doesn't help.

    When a report is run from the CRM SERVER, the following error appears - "An error occurred during report rendering."
    [MissingDataSourceCredentialsException: One or more data sources is missing credentials]

    Thursday, May 27, 2010 6:02 AM
  • Hi,

    have you installed at least Rollup 7 (it brings support for SQL 2008 R2)? Have you deployed the Reporting Services Connector?

    • Marked as answer by Elka_ Tuesday, June 1, 2010 1:10 PM
    Friday, May 28, 2010 7:49 PM
  • Hi,

    have you installed at least Rollup 7 (it brings support for SQL 2008 R2)? Have you deployed the Reporting Services Connector?


    I reinstall Reporting Services Connector with update. It helped. Thank you.
    Tuesday, June 1, 2010 1:11 PM