• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

sql 7 on NT4 wanting to move to win2003 and sql2000

hello all

i am running a NT4 sp6a machine w/ SQL7.  I am getting frequent crashes and its time to upgrade.

so...my 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

chris
0
cyouseph
Asked:
cyouseph
  • 2
1 Solution
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
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).
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
Here ya go:
http://support.microsoft.com/default.aspx?scid=kb;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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now