upgrade crm 4.0 to SQL 2008 R2 RRS feed

  • Question

  • We have CRM 4.0 and are on Rollup 20. I wanted to know if there are any considerations for moving the database to a SQL 2008 R2 server.

    • Our plan is to stand up a new DB server
    • Shut down the CRM services
    • Copy database to new 2008 R2 server
    • Swap names and IP address for the database servers
    • Turn CRM services back on.

    CRM web servers should not know there was any change since they will be pointing to the same named DB server as they were. Are there any other considerations such as the SSRS data connector? Our SSRS reports are on a different server which is running SSRS 2005.

    Any suggestions are greatly appreciated. 

    Thursday, May 17, 2012 4:28 PM

All replies

  • According to the Implementation Guide, the SSRS and SQL servers must be on the same version of SQL.

    Thursday, May 17, 2012 8:24 PM
  • Hi Florida Guy,

    Moving the databases to SQL Server 2008 will not cause any issues. As you probably verified, SQL Server 2008 is definitely supported for hosting the Microsoft Dynamics CRM 4.0 databases. 


    But there are few thing that will not work if you complete the steps you described above. 

    Copying all your Microsoft Dynamics CRM 4.0 Databases (MSCRM_CONFIG and <org>_MSCRM) will not bring all the required configurations.

    You will need to retrieve the SQL Server Agent Jobs that were created by CRM. You will also need to recreate all the logins that were created by the installation wizard on you SQL Server Instance. 

    Finally test it before you do it, and prepare your rollback plan! 

    Hope this helps! If it does, feel free to click on the "Helpful" button :) 


    Tuesday, May 22, 2012 3:52 PM