Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: SQL Server 2000 and 2005 Express on the same machine?

    Can I install SQL Server 2005 Express Edition on the same server where I already have SQL Server 2000 Enterprise Edition?

    Doing this also includes replacing .Net Framework 1.1 with 2.0, could that cause any disturbances to the already existing SQL Server 2000 ?

    (None of these two databases are heavy production databases)

  2. #2
    Join Date
    Dec 2005
    Posts
    74
    I don't know about the Server software, although I believe reading a Microsoft document stating that you can do that, but as far as the .Net framework is considered - 2.0 is not an upgrade to 1.1, it is a rightful departure from it, and thus they will coexist very peacefully on the same computer. I'd search the Microsoft knowledge base about SQL Server 2000 and 2005 Express, there should be something authoritative about it there. I, too would be curious to find out how it actually works.
    Kamen

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can definitely run SQL 2000 and SQL 2005 on the same machine, but any one machine can only have one default (un-named) instance. As long as at least one of the two uses a named instance (which Express uses by default), you'll be fine.

    -PatP

  4. #4
    Join Date
    Jul 2002
    Posts
    229
    So, having 2000 and 2005 in parallel is no more dramatic than having multiple 2000 instances then, in summary?

    And, I saw some web page where someone said SP4 should be installed before installing SQL Server 2005. I'm not
    sure if they meant SP4 of Windows or SP4 of SQL Server, though. Any ideas?
    Last edited by Coolberg; 08-24-06 at 06:11.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Technically SQL Server 2000 sp3a is required in order to install SQL 2005, but as long as the machine has less than 4 Gb of total RAM I really prefer to apply SQL 2000 sp4 and SQL 2005 sp1.

    -PatP

  6. #6
    Join Date
    Jul 2002
    Posts
    229
    Eh... do you really mean "less than 4Gb", not "at least 4Gb" ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •