Forum Moderators: open
Operating System Requirements
The SQL Server 2000 trial software requires one of the following operating systems:
Windows Server 2003*
Microsoft Windows 2000 Server with Service Pack 1 (SP1) or later
Microsoft Windows NT® Server 4.0 with Service Pack 5 (SP5)
Microsoft Windows XP Professional
Microsoft Windows XP Home Edition
Microsoft Windows 2000 Professional
* Requires SQL Server 2000 SP3a to be applied.
It was this posting that led me to believe that SQL would run on Web Edition of 2003. (if the trial version would run on ANY version of 2003, why wouldn't the FULL version?) Now I have to basically pitch WE 2003 and buy the more expensive standard edition. Just another underhanded example of M$ cashing in. Doesn't help out small businesses at all.
Anyone want a discounted Server 2003 Web Edition?
Limitations
Windows Server 2003, Web Edition, is designed specifically for dedicated Web serving needs, and its functionality has certain limitations as follows:* Although computers running Windows Server 2003, Web Edition, can be members of a Microsoft Active Directory® service domain, Windows Server 2003, Web Edition, cannot be a domain controller. Consequently, organizations cannot use Windows Server 2003, Web Edition, alone to apply certain management features, including Group Policy, Software Restriction Policies, Remote Installation Services, Microsoft Metadirectory Services, Internet Authentication Service (IAS), and others.
* Organizations cannot use Windows Server 2003, Web Edition, to deploy enterprise Universal Description, Discovery, and Integration (UDDI) services. UDDI is an essential component for enabling discovery and reuse of XML Web services.
* Organizations cannot use Windows Server 2003, Web Edition, to deploy Microsoft SQL Server™.
For these capabilities, the following editions of Windows Server 2003 can be used instead:
* Windows Server 2003, Standard Edition.
* Windows Server 2003, Enterprise Edition.
* Windows Server 2003, Datacenter Edition.
From [microsoft.com...]
Also on the SQL Server requirements page it lists the operating systems that it will run with:
[microsoft.com...]
What led you to believe that Windows 2003 doesn't run SQL 2000?
It's Web Edition of Server 2003. It won't because I tried and tried. Then I found this posting in the M$ knowledgebase in reply to someone asking why SQL wouldn't install:
Subject: Re: SQL2k standard on Win2k3 Web Ed. Wont install
From: "Geoff (last name ommited)" <email ommited> Sent: 7/7/2004 12:23:12 PMThere is a pretty simple answer for this one. You can't run SQL Standard on
Windows Server 2003 Web Edition.See the following link for supported OS editions for SQL Server 2000:
[microsoft.com...]
That link takes you to a place that says:
Minimum Requirements
Processor Intel Pentium or compatible 166-megahertz (MHz) or higher processor
Operating System• SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:
Windows Server 2003, Standard Edition
Windows Server 2003, Enterprise Edition
Windows Server 2003, Datacenter Edition
Windows® 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT® Server version 4.0 with Service Pack 5 (SP5) or later
Windows NT Server 4.0, Enterprise Edition, with SP5 or later• SQL Server 2000 Evaluation Edition and Developer Edition can run on the following operating systems:
Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional
Windows NT Workstation 4.0 with SP5 or later• SQL Server 2000 Personal Edition2 and SQL Server 2000 Desktop Engine (MSDE) can run on the following operating systems:
Operating systems listed above for Enterprise, Standard, Evaluation, and Developer Editions
Windows Server 2003, Web Edition1 (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)
and does NOT list Server 2003 Web Edition.
No matter what I try to do to trick it, all I can get SQL to do it pop a tiny window up, which quickly disappears... then nothing happens. We have Personal1 and Standard Editions, and thy just won't work.
Now, back to Win 2000 Server.
I went to Microsoft's site and found what looks like the same info you just posted.
You're not missing out on anything though ... SQL 2000 runs about the same on Windows 2000 as it does on 2003, the only difference I've noticed with 2003 is that I can use up to 16 GB of RAM with SQL enterprise. If you're not using that much dont worry about it, just fence your Windows 2003 copy on ebay.
SQL 2000 runs about the same on Windows 2000 as it does on 2003, the only difference I've noticed with 2003 is that I can use up to 16 GB of RAM with SQL enterprise. If you're not using that much dont worry about it, just fence your Windows 2003 copy on ebay.
Yeah, we don't need that much RAM use for our db. Not that big.
I think we will be "ebaying" the Web Edition. Maybe someday I'll try out SE or Enterprise of 2003. Not too excited about it anymore.
Normally their software will pop up an error message saying that the product doesn't work with the version of Windows you're running, like if you try to install SQL 2000 Enterprise on Windows 98. The fact that the window just "disappeared" in your installation attempt makes me think that maybe Microsoft didn't realize that it wasn't going to work until later so they removed it from the list of supported operating systems after the fact. I certainly hope this isn't the case though.
I certainly hope this isn't the case though.
Yeah, me too. Seems like it is though because I don't get any message saying it's not compatible with that version. I would expect that type of window if this was something they knew about beforehand. Also, not finding this issue anywhere shortly after 2003's release (when I ordered the software) points to this being an "oops" type thing on M$'s part.
Wonder what other "undocumented features" it holds.
You probably have thought of it, but what about mySQL? That works fine.
Steve
