Hi,

I am the newbie about SQL server.

I am facing a problem about install SQL2000 standard server over Windows2003
SP2 standard server.

While I clicked the setup.exe, it prompted me the following message:

SQL Server 2000 SP2 and below is not supported by this version of Windows.
Please apply sp3 after installation of SQL server 2000.

When I searched from the internet, it shows the result with SQL2000 sp3a and
SQL2000sp4. Those of them consist of 3 components

Which SP should I go to install its components?

In my working environment, it contains PC/ Server with NT4.0 Std Server,
Win98, WinME, Win2000 Std Server and Win2003 Std Server. They need to
connect with the SQL2000 via the in-house application program.


Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/downloads/d...f-acace5369fa3

Database Components
Downloadable file name: SQL2KSP3.exe SP3a

Analysis Services Components
Downloadable file name: SQL2KASP3.exe SP3a

SQL Server 2000 Desktop Engine(MSDE)
Downloadable file name: SQL2kdesksp3.exe SP3a


Microsoft SQL Server 2000 Service Pack 4
http://www.microsoft.com/downloads/d...displaylang=en

Database Components (Download file: SQL2000-KB884525-SP4-x86.EXE)

Analysis Services Components (Download file:
SQL2000.AS-KB884525-SP4-x86.EXE)

SQL Server 2000 Desktop Engine (MSDE) Components (Download file:
SQL2000.MSDE-KB884525-SP4-x86.EXE)
PS: Instructions Important: SQL Server 2000 Service Pack 4 is not supported
on Windows NT 4.0, Windows Millennium Edition and Windows 98 platforms.

Thanks for your help first.

tlee

tlee
But permit me to ask you why would you want to install the product that is
already out of official support?



"tlee" <tlee (AT) nilmail (DOT) com> wrote

Hi Uri,

Since, I need to upgrade our sever from Win2000 to Win2003. And it is
required to re-install SQL2000 into the new Server 2003.

They are already licensed. Due to the new server, we have purchased Win2008
down grade version. Our boss is not willing to spend more to purchase SQL
latest version. Besides, the in-house application SW is based on SQL2000
also.

Thanks
tlee

tlee
Your boss will probably spend more money if SQL Server 2000 has some bug
that is fixed in the next version but affects your app.


"tlee" <tlee (AT) nilmail (DOT) com> wrote

Sorry miss reading your suggestion.

If update to SP4, is it properly connected from WinNT, Win98 and WinMe PCs ?

thanks

Database Components (Download file: SQL2000-KB884525-SP4-x86.EXE)

tlee (tlee (AT) nilmail (DOT) com) writes:
Yes.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi Erland, Daniel,

Thanks for your kind replies.

tlee

it's my understanding that you probably need the package
SQL2000-KB884525-SP4-x86.EXE and if you are using Analysis Service, then you
also need the package SQL2000.AS-KB884525-SP4-x86.EXE. In case of doubt,
download both but probably that you would already knew it if you are also
using Analysis Service.

The other two packages are for the MSDE 2000 (MSDE is the free version of
SQL-Server 2000 and it's equivalent to the Express Edition of SQL-Server
2005 and 2008) and the Itanium version and quite probably, these two are not
what you need.

Finally, the notice about the lack of support for Windows NT 4.0, Windows
Millennium Edition and Windows 98 platforms is for when you have installed
MSDE-2000 or the Standalone version of SQL-Server 2000 on one of these
platforms and has nothing to do with the capability of these machines to
connect to an instance of SQL-Server 2000. If the machines on your network
can already connect to the older installation of SQL-Server 2000, quite
probably that they will be able to do the same toward the new installation.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

"tlee" <tlee (AT) nilmail (DOT) com> wrote

Hi Sylvain,

Thank you very much for your detail message !!!

tlee