locked
Can we run SQL Server 2000 and 2008 side-by-side? RRS feed

  • Question

  • We are setting up a test environment where we want to test both our legacy (SQL Server 2000) and "next gen" apps (targeting SQL Server 2008). We will also want to test on both XP and Windows 7. Can we run both versions of SQL Server on Windows 7 64-bit, with SQL Server 2000 still in 32-bit "mode" or whatever?
    Monday, December 12, 2011 10:48 PM

Answers

  • Hi B Clay Shannon,

    SQL Server 2000 setup is not supported on Windows 7, but later versions of SQL Server clients (such as the SQL Server Native Client, SQL Server Native Client 10.0, and recent versions of Microsoft Data Access Components shipped with Windows) are supported on Windows 7, and are able to connect to SQL Server 2000.

    Please refer to this online article for more details.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Horizon_Net Tuesday, December 13, 2011 1:02 PM
    • Marked as answer by Peja Tao Wednesday, December 21, 2011 2:15 AM
    Tuesday, December 13, 2011 7:30 AM

All replies

  • yes. you can have both sql 2000 and 2008 running on same server as different instance

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    Monday, December 12, 2011 10:56 PM
  • Hi B Clay Shannon,

    SQL Server 2000 setup is not supported on Windows 7, but later versions of SQL Server clients (such as the SQL Server Native Client, SQL Server Native Client 10.0, and recent versions of Microsoft Data Access Components shipped with Windows) are supported on Windows 7, and are able to connect to SQL Server 2000.

    Please refer to this online article for more details.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Horizon_Net Tuesday, December 13, 2011 1:02 PM
    • Marked as answer by Peja Tao Wednesday, December 21, 2011 2:15 AM
    Tuesday, December 13, 2011 7:30 AM
  • Actually, it is possible to install SQL Server 2000 to Windows 7 according to Sudarpo's procedure at:

    http://www.sudarpo.net/2009/09/installing-sql-server-2000-in-windows-7-guide/

    Note that the author shows how to do it, but he does not recommend it for any production use.  (And I certainly do not recommend it for production use.)

    But, if it helps you test, then fine.

    RLF


    PS - Nonetheless, if you can run on two machines side by side, then Peja's answer about using the tools is a fine answer.
    • Edited by SQLWork Tuesday, December 13, 2011 3:20 PM PS
    Tuesday, December 13, 2011 3:18 PM