my computer is running windows xp pro sp1 this afternoon i tried to install sql server 2000 standard edition and it came up with this message....

"Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for installation."

is it possible to install the sql server stuff on xp? the system requirements do not mention xp as one of the operating but i assume thats due to the fact windows 2000 was the most recent at the time.

Do you have SP 3a?

This is not a compatibility issue. This is MS policy to let you install the thing on server OSes only. If you look at the supported OS list you don't see any desktop OSes there.

God bless marketing.

Windows XP Pro only supports 10 connections (I think), so is unsuitable for running an Enterprise database, and that is likely why MS has decided not to let it install on a desktop OS. The developer edition, or the MSDE versions of SQL2000 will install into winxp if you are set on using any of those. Check out this page ... http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

thank you all for your help.

just a quick question about sql server will it install on nt4?

Not on NT Workstation. Yes on NT Server.

On a desktop version OS you can only run Personal or MSDE versions of SQL Server.

Hello.

I have the some error on "Windows XP" and on "Windows Server 2003"!

I have Microsoft SQL Server 2000 Enterprise Edition without SP3. I downoad SP3 but I couldent install it because it need to be after install the databse.

On the Microsoft site I found this:

But How I can install the database on "Windows XP" or "Windows Server 2003" without SP3 because SP3 I will install after!?!?

You need a Windows Server OS to run the Enterprise edition of SQL Server 2000. It will not install on Windows XP so forget it. If you want SQL Server to run on Windows XP then you need to get hold of the Developer or Personal editions. If you bothered to read the above posts then you would already know this.

You should be able to install the enterprise edition onto Windows 2003 as you mentioned, but it won't work correctly until you have updated it with sp3.

Ok, I will try again to install the Micorsoft SQL Server 2000 on Windows Server 2003 when I have time.

But you read that say Microsoft:
In an effort to provide customers with more secure products, Microsoft Windows Server™ 2003 supports only SQL Server 2000 with Service Pack 3 (SP3) or later and MSDE 2000 with SP3 or later.

How Can I install If It doesn't have within SP3!?!?!?!?

Install SQL Server 2000 Enterprise, then install SQL Server SP3 patch to update the database. They are not talking about Windows Server 2003 SP3 because that doesn't exist.

I run the installation on "Windows Server 2003" and It's say just this:

SQL Server 2000 SP2 and below
Microsoft

--------------------------------------------------------------------------------

Issue Description:

SQL Server 2000 SP2 and below is not supported by this version of Windows.




P.S. Meybe If I install the database on "Windows Server 2003" and after install SP3, meybe It work normal.

Yes, that is correct.

Just ignore the error message. Apply the SP3 immediately after the install.

Ok, thanks.

Getting the error!

Hi, I am trying to install SQL Server 2000 Enterprise Edition on a Windows Small Business Server 2003 Standard. I got the first warning, ignored and continue, but then get the second message that says I can only install client components.

Is there a trick around this or am I stuck and must purchase the premium edition?

Thanks.

@all who are trying to install sql server 2000 enterprise or standard to windows xp pro

I figured out where the setup routine checks for the os version.
It's stored in the setup.ins File in the setup-directory.

If you replace this file with the one from the developer edition or the evaluation version of sql server 2000 the installation should be successful.

I'll try this solution today on my pc @ home and report here if anybody wants me to.

Regards
MacGyver

Got it. After replacing the .ins File with the one provided with the developer version the setup continued with the installation.

It did not affect versioning of the SQL Server. The Infobox said, I installed the enterprise version. I don't know if this is legal (suppose it is not), but it worked 4 me.

I think it doesn't matter too much if you install it this way for testing purposes.
In real production environments you'd surely prefer to install on a server, because Windows XP is limited in RAM, Number of CPUs, does not provide clustering services and has none of the fancy server features, a good old Windows Server 2003 can provide.

Thank you!

Thank you MacGyver! You ROCK!

where can we find this file???? i really need to install the enterprise edition on my winxp machine.... any help would be greatly appreciated...