locked
CRM4.0 reports do not work on new win2008, sql2008 env. RRS feed

  • Question

  • Hi all,

    On a new win2008 server, I installed CRM 4.0, and SQl2008. restored a CRM database from another win2003, sql2005 CRM env (another domain). In the SQL 2008, I added the uses, groups of current domain to the restoed CRM database XXX_MSCRM.

    Then on the win2008 server, I imported the restored CRM database using the CRM deployment manager tool. the new CRM instance works correctly, but the reposrts do not work. I installed CRM data connector on win2008 server, reports still not work.
    I've checked the report server.
    on http://aa/ReportServer, I can see 2 CRM orgnizations dirs there. (1 is the default org, another is the imported one). Gointo the CRM org dir, I see a dir named "4.0", go into it, can see many reports(just GUID) listed there. I click one, it asks me to enter user name and password. I enter my domain account name and password, click "view report" button, get the following message.
    • An error occurred during client rendering.
      • An error has occurred during report processing. (rsProcessingAborted)
        • Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
          • Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

    I go to http://aa/Reports, also can see the 2 crm org folders, but there are no items in those folders.

    In Reporting services configuration manager, it states that report server db name is ReportServer, report server mode is native, report server service account is network Service.

    any advice would be appreciated.

    thanks,
    Alan


    I use the CRM SRS data connector, so the datasource is created by the connector.
    The reports on report server work correctly when I provide the username and password got from the org_MSCRM.systemuserbase.

    Just can't view the reports (include out of box reports) in CRM.
    • Edited by alanzhouoad Tuesday, December 15, 2009 7:40 AM clarification
    Friday, November 20, 2009 3:24 AM

Answers

  • I'm not sure I follow the exact steps you took, but it seems to me that the best path would be to first backup your SQL 2005 db then upgrade your SQL 2005 db to SQL 2008 rather than restoring a 2005 backup to SQL 2008, then tweaking that by adding users, groups, etc.

    You have several things going on, moving to a new domain, upgrading SQL and upgrading the OS.  You'll need to follow a systemetic approach as you are dealing with several changes.  If you don't follow best practice for this type of change, I've generally found that SQL reports will have a problem.

    Here is the article for redeploying CRM from one domain to another:

    http://support.microsoft.com/default.aspx/kb/952934

    The articles below that Frank shared are steps that have to be carefully followed for updgrading the OS and SQL.

    http://support.microsoft.com/kb/950100

    http://support.microsoft.com/kb/957053

    I will be working through a similar upgrade within the same domain and I plan to take the following steps:

    first upgrade SQL 2005 to 2008 on the production server (I will first backup the 2005 db)
    install CRM 4 and SQL 2008 on the new machine with the Windows 2008 OS
    restore the already upgraded CRM database to the SQL 2008 on the new machine,
    mport the CRM Org to the new machine
    install the SRSS Connector on the new machine.

    the above is a very high level plan.  Each step above will require additional steps.  The details for the steps can be found in the KB articles above.
    Best Regards, Donna
    • Proposed as answer by Donna EdwardsMVP Friday, December 4, 2009 2:07 PM
    • Marked as answer by Jim Glass Jr Tuesday, February 23, 2010 6:15 PM
    Friday, December 4, 2009 2:06 PM

All replies

  • Hi Alan,

    Some questions:

    When you Install CRM Server, did you download the CRM Installation Updates? (this is imperative for w2K8 Environments, this fix a issue with reporting services)
    Did you restore all CRM database from another Domain? I mean MSCRM_CONFIG and ORG_MSCRM
    I ask you this because the right procedure in this kains of movements is Install CRM from the Scratch, Check that all works (Including Reports and WorkFlws) and then Make an Import Organization Procedure with CRM Organization Manager Console. this Maps all Users and Reports to a new Domain.

    Regards
    Friday, November 20, 2009 9:04 PM
  • Some ideas try:

    - Did the reports work on the pre-redeployed state?  If not - check the following on CRM 4.0 support on Win2008 and SQL2008:

    http://support.microsoft.com/kb/950100

    http://support.microsoft.com/kb/957053


    - Under the CRM deployment Manager, check if the Organziation detail settings are ok

    - Repair or reinstall your Microsoft CRM Server only (keep data)


    http://www.workopia.com/Links.htm

    Friday, November 27, 2009 6:57 PM
    Moderator
  • Hi Frank,

    thanks for your advices.

    Sorry, I don't know what you meant the pre-redeployed state is.  The reports worked correctly on the Win2003 and SQL2005 env. before. 
    And I didn't encounter the issues described in the MS KBs.
    I can't reinstall the MS CRM server for now.

    Regards,
    Alan
    • Edited by alanzhouoad Monday, November 30, 2009 2:41 AM spell error
    Monday, November 30, 2009 2:40 AM
  • Are you using 2008 or 2008 R2 ?
    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://www.mscrm.cn
    Monday, November 30, 2009 3:36 PM
    Moderator
  • windows server2008
    Tuesday, December 1, 2009 2:26 AM
  • I think that the CRM data connector changed the MSCRM_dataSource (MSCRM data extension) in reporting server so I was prompted to input username and password viewing reports on reporting server. (http://aa/reports and http://aa/reportserver)

    Now I changed the xxx_MSCRM\4.0\MSCRM_dataSource to data source type "ms sql server",  Windows integrated security.
    then I can view the reports of xxx_MSCRM correctly on http://aa/reports and http://aa/reportserver.
    But on CRM website, still can't view those reports.

    I find an article http://blogs.msdn.com/crm/archive/2009/11/30/crm-data-connector.aspx.
    I tried the approach b) Configure Reporting services App pool on the computer to user a different account. But no effects.
    Tuesday, December 1, 2009 7:04 AM
  • Hi alanzhoupsd,

    You need to upload the report via CRM, not directly load into the SSRS.
    CRM will change the data source to using the data connector, you don't need to do anything.


    Cheers,
    Jim

    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://www.mscrm.cn
    • Marked as answer by Donna EdwardsMVP Friday, December 4, 2009 1:48 PM
    • Unmarked as answer by alanzhouoad Wednesday, December 9, 2009 2:53 AM
    Friday, December 4, 2009 11:01 AM
    Moderator
  • I'm not sure I follow the exact steps you took, but it seems to me that the best path would be to first backup your SQL 2005 db then upgrade your SQL 2005 db to SQL 2008 rather than restoring a 2005 backup to SQL 2008, then tweaking that by adding users, groups, etc.

    You have several things going on, moving to a new domain, upgrading SQL and upgrading the OS.  You'll need to follow a systemetic approach as you are dealing with several changes.  If you don't follow best practice for this type of change, I've generally found that SQL reports will have a problem.

    Here is the article for redeploying CRM from one domain to another:

    http://support.microsoft.com/default.aspx/kb/952934

    The articles below that Frank shared are steps that have to be carefully followed for updgrading the OS and SQL.

    http://support.microsoft.com/kb/950100

    http://support.microsoft.com/kb/957053

    I will be working through a similar upgrade within the same domain and I plan to take the following steps:

    first upgrade SQL 2005 to 2008 on the production server (I will first backup the 2005 db)
    install CRM 4 and SQL 2008 on the new machine with the Windows 2008 OS
    restore the already upgraded CRM database to the SQL 2008 on the new machine,
    mport the CRM Org to the new machine
    install the SRSS Connector on the new machine.

    the above is a very high level plan.  Each step above will require additional steps.  The details for the steps can be found in the KB articles above.
    Best Regards, Donna
    • Proposed as answer by Donna EdwardsMVP Friday, December 4, 2009 2:07 PM
    • Marked as answer by Jim Glass Jr Tuesday, February 23, 2010 6:15 PM
    Friday, December 4, 2009 2:06 PM
  • seems I took a wrong step restoring a 2005 backup to SQL 2008.
    But the CRM works correctly and has many new records from restoring. just the reports do not work.

    Is there a way fixing the crm reports issue in my crm environment?

    Thanks in advance.

    Regards,
    Alan
    Tuesday, December 8, 2009 2:40 AM
  • Do you mean I can upload the reports in CRM again to fix this issue?

    Regards,
    Alan
    Tuesday, December 8, 2009 2:42 AM
  • Hi Jimmy,

    yes, I downloaded the CRM installation updates.
    I just moved the org_MSCRM db.

    Is there a way fixing the crm reports issue in my current crm environment?

    Regards,
    Alan
    Wednesday, December 9, 2009 2:55 AM
  • Hi Jimmy,

    I read the kb http://support.microsoft.com/default.aspx/kb/952934
    In my case, I do not need to restore the MSCRM_CONFIG databse.

    Regards,
    Alan
    Thursday, December 10, 2009 3:02 AM
  • I've tried uploading the reports rdl file in CRM and creating new reports manually in CRM.
    They al do not work.

    Help me!!!!!!!
    Thursday, December 10, 2009 3:04 AM
    • Reports on http://aa/ReportServer always show:

    • ReportServerAn error has occurred during report processing. (rsProcessingAborted)
      Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
      Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
    Thursday, December 10, 2009 8:33 AM
  • alanzhoupsd, I had the same issue. In my case the reason was that there were 2 CRM datasources in Reporting. One was correct and one incorrect. And all reports published with CRM was referenced to the incorrect DataSource. So I just corrected that datasource. I don't know why there are 2 datasources.
    You can edit datasource here http://rsserver/Reports_CRM If you cannot see anything here just click "Show Details"

    P.S. sorry for my English :)
    • Proposed as answer by Dvar Tuesday, December 15, 2009 6:13 AM
    Tuesday, December 15, 2009 6:13 AM
  • thank you Dvar.

    Mine is not the CRM datasource problem. I use the CRM SRS data connector, so the datasource is created by the connector.
    The reports on report server work correctly when I provide the username and password got from the org_MSCRM.systemuserbase.

    Regards,
    Alan
    Tuesday, December 15, 2009 7:36 AM
  • Hi Alan,

    Did you install the Update Roll-Up 7?. If not i recommend the follow Steps:

    - Back up CRM databases and ReportServer  DB.
    - Install Roll-Up7 in CRM Server and CRM-SRS and all others CRM componentes that you have.
    - Restart the CRM and Reports Server Machines

    If this still doesn't work

    - Disable and delete the imported organization then delete Organization database in SQL.
    - Do the import procedure from the scratch.
    - When you're in User mapping Step, make sure to map correctly the Administrator Users.

    this help me to solve many reports issues in w2k8 Environments.


    Rollup7
    http://www.microsoft.com/downloads/details.aspx?FamilyID=A4893988-7804-4E23-AB58-740441CC696E&displaylang=en

    Let me know if works
    Best Regards


    • Proposed as answer by Jimmy Morales Thursday, December 17, 2009 2:14 PM
    Tuesday, December 15, 2009 2:43 PM