SQL Server 2000 on Windows Server 2000 Web Edition

I finally pulled my dual-Xeon Dell upstairs to where I recently moved my desk. My intention was to test the new Enterprise Library. So, Windows Server 2003... check; Visual Studio 2003... check. Cool. So I download Enterprise Library... but I forgot all about SQL Server. After I consolidate my old MSDN disks (my MSDN expired last year) I pull out my MSDN disks, and go to install the Enterprise Edition.

And... nothing. Hmm. No worries. I open up explorer, navigate to the setup directory and double-click sqlsetup. I'm greeted with this happy little error: Windows cannot open this application since it has been disabled. After about 15 minutes of google searches (finding the right answer - not just the first answer), I discover that SQL Server 2000 Enterprise Edition will not install on Windows Server 2003 Web Edition. Am I only the only person that didn't know this?

I don't really want to reinstall the OS just to bump myself upto Standard Edition (because then I'll have to reinstall VS2003); however I'd prefer to run the real version of SQL 2000... not just the Personal Edition. Woah is me. Crap. I guess I'll just install the personal edition, damn-it.

I flip through my MSDN disks again, but I don't see the personal edition for some reason. Now I'm waiting on my broadband connection to download the ISO from subscriber downloads (Volume License Edition provided by my customer). Now if I don't find that ISO-Mount tool, I'll be forced to burn a disk; and to think, all I wanted to do was play with the Enterprise Library (aka ACA.NET). I guess I could look at it now, but what I'm most interested in is the new Data class. Of all the Application Blocks, I've only found a need for the Exception Management block and MSDAAB (SqlHelper). Sometimes tech can be so frustrating.

UPDATE: Apparently the Personal edition doesn't work either. Damnit! I chose Web Edition of Windows 2003 because I figured I didn't need Enterprise or Standard edition to do some basic development and toying with new technology. Lesson learned. Use the top of the line everything or Microsoft will help me.

posted @ Thursday, February 03, 2005 9:51 PM

Print

Comments on this entry:

# re: SQL Server 2000 on Windows Server 2000 Web Edition

Left by Andrew at 4/12/2005 9:41 AM
Gravatar
I also got stumped when I could not install SQLServer 2000 on Windows Server 2003 Web Edition. Aaaaarrrrrgggghhhh!

# re: SQL Server 2000 on Windows Server 2000 Web Edition

Left by Sferix at 11/18/2005 7:58 AM
Gravatar
WTF!?!

me too...

Your comment:



 (will not be displayed)


 
 
 
 
 

Live Comment Preview:

 
«November»
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345