Post reply

SQL Server 2000, 2005 and 2008 on same machine

  • January 27, 2010 at 1:49 am

    #209473

    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

  • January 27, 2010 at 4:04 am

    #1109197

    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

  • January 27, 2010 at 7:44 am

    #1109300

    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

  • January 27, 2010 at 9:52 pm

    #1109720

    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.

  • January 27, 2010 at 10:23 pm

    #1109732

    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

  • January 27, 2010 at 10:35 pm

    #1109736

    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

  • January 27, 2010 at 10:43 pm

    #1109739

    Thanks vstitte and Jason

  • January 27, 2010 at 10:44 pm

    #1109741

    You are welcome.

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

  • January 27, 2010 at 10:59 pm

    #1109749

    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