Legacy (CRM 4.0) Deployment question RRS feed

  • Question

  • Hi,

    Our aging CRM 4.0 installation is starting to buckle a little bit. But I need to keep it going a while longer.

    At the moment it's hosted on

    1 x Windows 2003 Server Standard 32bit containing Domain Controller and SQL 2005 Standard
    1 x Windows 2003 Server Standard 32bit containing Web Application

    Being Standard edition obviously we're restricted to 4GB RAM, so I had the idea to firstly upgrade the DB server to Enterprise edition to utilise more RAM. I installed a new 2003 Ent server with 16GB RAM and SQL 2008 R2 and joined it to the domain.

    Then I used deployment manager to move the DB to the new server.

    Everything works great with this, except for the last DB i'm trying to move the deployment wizard fails with "object not set to instance of an object"

    It seems to have worked, except none of the reports work.

    Any ideas what could be wrong?


    Wednesday, September 2, 2015 1:29 PM

All replies

  • Did you configure SSRS on the new SQL Server and then edit the organization properties in Deployment Manager to use the new URL for SSRS?

    What error(s) are you getting when you run a report?

    Also, did you move the configuration database (MSCRM_CONFIG) to the new SQL server? If you did, I think you need to update a registry setting on the CRM server to tell it to look to the new SQL server instead of your SQL 2005 standard server.

    Monday, September 7, 2015 10:21 PM