Installing different SQL Server versions on one machine

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

    When you register, you’ll also receive targeted emails from my team of award-winning editorial writers.  Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

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