Home > Ask the SQL Server Experts > Greg Low - Development Questions & Answers > Installing different SQL Server versions on one machine
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Installing different SQL Server versions on one machine

Greg Low EXPERT RESPONSE FROM: Greg Low

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 11 September 2007
Can you install two different versions of SQL Server on the same box?

>
EXPERT RESPONSE
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.

    		•

    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


    RELATED CONTENT
    SQL Server installation
    SQL Server consolidation: Why it's an optimization technique
    SSIS error message due to installation problem on SQL Server 2005
    Get SQL Server log shipping functionality without Enterprise Edition
    How to create a SQL Server linked server to DB2
    Tuning SQL Server performance via disk arrays and disk partitioning
    Virtual database storage for SQL Server: Friend or foe?
    Tutorial: Migrating to SANs from local SQL Server disk storage
    How to restore SQL Server database to transition server during upgrade
    Storage area network (SAN) basics every SQL Server DBA must know
    Tips for moving from SQL Server local disk storage to SANs
    SQL Server installation Research

    SQL Server 2005 (Yukon)
    SQL Server consolidation: Why it's an optimization technique
    Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
    Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
    SSIS error message due to installation problem on SQL Server 2005
    SQL Server data conversions from date/time values to character types
    Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
    How to configure Database Mail in SQL Server 2005 to send mail
    How to use rank function in SQL Server 2005
    Manage traces in SQL Server 2005 Analysis Services with XMLA commands
    Tutorial: SQL Server 2005 Analysis Services
    SQL Server 2005 (Yukon) Research

    Greg Low - Development
    Copy stored procedure between SQL Server 2005 databases
    Should developers have permissions to SQL Server production queue?
    Schedule stored procedure and save output to network drive
    Query to find SQL Server database names created by users
    Is it possible to find disabled indexes in SQL Server 2000?
    SQL Server id permission to create and modify tables
    Problem attaching stored procedure and SQL Server trigger
    Calling an extended stored procedure in SQL Server 2005
    Multiple SQL Server instances vs. multiple databases
    VARCHAR and NVARCHAR data types in SQL Server 2005

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    application server  (SearchSQLServer.com)
    Yukon  (SearchSQLServer.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary



    Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice

    HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




    All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts