New Installation of SQL Server 2000

Hi,
I installed sql server 2000 sp2 standard edition on Windows 2003, when
installing, it said "This version is not support on this os", but I was told
to continue installing the software and that I could install the latest
security patches to bring it up to date. Will that work? Do I need to do
anything else? SQL Server 2000 is up and running on the box. When running
the statement " select @.@.version" it informed me that I was at 8.00.194
patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was
trying to download the lasted patch and it asked for that info. Thanks.--
New SQL Server DBANewbie wrote:
> Hi,
> I installed sql server 2000 sp2 standard edition on Windows 2003, when
> installing, it said "This version is not support on this os", but I
> was told to continue installing the software and that I could install
> the latest security patches to bring it up to date. Will that work?
> Do I need to do anything else? SQL Server 2000 is up and running on
> the box. When running the statement " select @.@.version" it informed
> me that I was at 8.00.194 patch level. How can I tell if SQL Server
> 2000 is 32 or 64 bit? I was trying to download the lasted patch and
> it asked for that info. Thanks.-- New SQL Server DBA
You didn't install SQL 2000 SP2. You installed SQL 2000 RTM (v194). The
installation program at the point SQL 2000 RTM was released didn't know
about Win2K3 and is giving you the error.
Install SP3a on the server and you should be ready to go.
David Gugick
Imceda Software
www.imceda.com