Upgrade SQL 2005 express to SQL 2008 R2 fails RRS feed


  • Since you have 2005 Express which was only offered 32 bit, you can't upgrade to 2008R2 Express x64 directly.  See the following blog post that shows the steps to do an upgrade to 2008R2 Express x86:


    What you did is install another SQL Express instance for the 2008R2 x64 instance.  You can either migrate your logins and user databases from your original 2005 instance to the new one and reconfigure your applications, upgrade to 2008R2 32 bit, or uninstall 2008R2 and the 2005 instance and start clean installing just the 2008R2 instance.

    Jonathan Kehayias | Senior Database Administrator and Consultant
    Feel free to contact me through My Blog or Twitter
    Please click the Mark as Answer button if a post solves your problem!
    • Proposed as answer by Naomi N Thursday, February 17, 2011 4:30 AM
    • Marked as answer by Alex Feng (SQL) Sunday, February 27, 2011 9:27 AM
    Thursday, February 17, 2011 2:08 AM