Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to Upgrade CRM 3.0 on SQL 2000 on SBS 2003 to CRM 4.0 on SQL 2008 SBS 2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Our client has a working CRM 3.0 install on SBS 2003 Pro box with SQL 2000.  They are purchasing a new server with SBS 2008 Pro and SQL 2008.  Normally, I would upgrade V3 to V4 then migrate to the new box.  However, since V4 won't run on SQL 2000 and V3 won't run on SQL 2008, what do I do?

    It seems that we'd have to upgrade SQL to 2005 on the old box, then upgrade CRM, then migrate.  Any comments are appreciated!

    Thanks!

    Susan
    Susan
    Monday, March 16, 2009 7:28 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Your plan to upgrade SQL on the older hardware seems to be the least complex path -  assuming you're comfortable that the hardware is stable long enough to upgrade to 2005. - (If you think your server is on the edge of failure, go the VPC route.)

    (If you do use the VPC, you'll need to redeploy a couple of times and that introduces risks - particularly if you don't create matching users for every user who has existed and worked in CRM since it was first installed.)

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Wednesday, March 18, 2009 2:13 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Alternatively, use a VPC and perform the upgrade there, redeploying the database. If the hardware in the old box isn't up for the upgrade, this can be a good way to go.

    Leon Tribe
    Want to hear me talk about all things CRM? Check out my blog
    http://leontribe.blogspot.com/
    • Proposed as answer by Leon TribeMVP Tuesday, March 17, 2009 6:27 PM
    Tuesday, March 17, 2009 6:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Your plan to upgrade SQL on the older hardware seems to be the least complex path -  assuming you're comfortable that the hardware is stable long enough to upgrade to 2005. - (If you think your server is on the edge of failure, go the VPC route.)

    (If you do use the VPC, you'll need to redeploy a couple of times and that introduces risks - particularly if you don't create matching users for every user who has existed and worked in CRM since it was first installed.)

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Wednesday, March 18, 2009 2:13 AM
    Moderator