SQL Server 2000, 2005 and 2008 on same machine

  • Hi,

    I already have SQL 2008 installed on my machine. I want to install SQL Server 2000 and 2005 on same machine. Now I have few questions as below:

    1. Can 2000, 2005, 2008 reside on same machine at a time?

    2. Is there any instance limitation, I mean can I have default instance of any version and named instance of others? ( I know there can be only one single instance)

    Thanks,

    Shailendra

  • Hi,

    1) Yes, you can install in different logical drives so that here will be no override.

    2) You can install 2000 and 2005 with different instance names.

    Thanks,

    Nagesh

  • Yep, they can all run on the same machine without issue, except of course that they'll compete for the resources available on that machine.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • nageshreddy_p (1/27/2010)


    Hi,

    2) You can install 2000 and 2005 with different instance names.

    Can Default instance be of any version (2000/2005/2008) or is there any limitation like e.g only 2008 can be default instance.

  • I don't think it matters, which one is the default instance. It can be either 2008 or 2005. There can be only one default instance and all other named instances have to be unique. This link has some information regarding side by side support for SQL Server instances with 2008.

    Working with Multiple versions of SQL Server

  • Default instance can be any of them.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks vstitte and Jason

  • You are welcome.

    And Jason - Thanks for the correction. I didnt read the earlier response clearly. Overlooked that SQL Server 2000 is also involved.

  • You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply