Installing different SQL Server versions on one machine

Can you install two different versions of SQL Server on the same box?

    Requires Free Membership to View

Yes you can. While you theoretically can install them in either order, I'd always suggest installing the software in the order it was released: SQL Server 2000 first, then SQL Server 2005.

Check out this helpful tip:   
  • Compatibility of SQL Server 2005 and 2000 coexisting
    So, you've decided to upgrade your databases to SQL Server 2005. Database expert Michelle Gutzait highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server 2000 machine. Also discussed are options for interaction between the two versions, such as: linked servers, multi-server administration and log shipping.
  • This was first published in September 2007

    Join the conversationComment

    Share
    Comments

      Results

      Contribute to the conversation

      All fields are required. Comments will appear at the bottom of the article.