sql 7 on NT4 wanting to move to win2003 and sql2000

Posted on 2005-05-16
Last Modified: 2010-03-19
hello all

i am running a NT4 sp6a machine w/ SQL7.  I am getting frequent crashes and its time to upgrade. question is how should i do this? upgrade sql 7 to sql2000 on NT4 then upgrade the os to win2003??

can i upgrade the OS to win2003 then upgrade sql7 to sql2000?

i had heard sql7 will not run on windows 2003

any help would be greatly appreciated

Question by:cyouseph
    LVL 95

    Expert Comment

    by:Lee W, MVP
    To run on Server 2003, SQL 2000 MUST be at service pack 3 or later.  So, I'd upgrade to SQL 2000 first (applying the service pack), then upgrade to Windows 2003.  ('ll Try to find documentation on this).
    LVL 95

    Accepted Solution

    Here ya go:;en-us;810391
    AS it says:
    If you want to upgrade to Windows Server 2003, and you are running SQL Server 6.5 or SQL Server 7.0 on Microsoft Windows NT 3.51, Windows NT 4.0, or Microsoft Windows 2000, follow these steps:
    1.    Evaluate and test your application on SQL Server 2000 and Windows Server 2003.
    2.    Upgrade to SQL Server 2000 SP3 or later.
    3.    Upgrade to Windows Server 2003.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now