Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: Install MS SQL Server 2000 on a MS Server 2003?

    Can I install MS SQL Server 2000 on a Microsoft Server 2003 box?
    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    yes but it will give you an info msg telling you that you will need sp2 or greater with sql 2000 because win2003 doesnt support sql2k on 2003
    this is because of the security updates in the service pack and the higher level of base security in windows 2003
    (ms doesnt want to compromise the security benefits of 2003 by allowing an unsecured SQL server to be installed on it. the service pack requires you to assign the sa account a password)

    you can acknowledge this statement but dont worry its just info. you will be able to continue with your installation.
    but after you finish, should load sp 2 or 3 etc....
    i

  3. #3
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    Thanks!

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    But having said that we do have some pre-requisites for the same. You will have to first install SQL2000. A warning message may come up saying that SQL Server2000 SP2 or lower is not supported on Windows 2003.But thats just a reminder for you to apply SP3a or later.

    When you first install SQL it will disable all network libraries except shared memory, preventing remote connections. Applying SP3a will re-enable them.

    Make sure its not Win2k3 Web Edition as the only version of SQL allowed on that is MSDE2000 SP3(a).

    http://www.winnetmag.com/SQLServer/A...992/41992.html for information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    thanks again

Posting Permissions

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