Home > Ask the SQL Server Experts > Michael Hotek Questions & Answers > Installing SQL Server 2000 on Windows XP
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Installing SQL Server 2000 on Windows XP

Michael Hotek EXPERT RESPONSE FROM: Michael Hotek

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 30 August 2004

I want to install SQL Server 2000 on WinXP and I got an error like this: "Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client component will be available for installation."

It is so odd because I had installed successfuly using the same CD on another machine. What is your opinion?


>
EXPERT RESPONSE

When installing SQL Server 2000 on a Windows XP machine, you could NOT have installed successfully on another machine using the same CD. The Enterprise Edition of SQL Server will ONLY install on a machine running Advanced Server. If you are not running Advanced Server (or NT Enterprise Edition), you will NOT be able to install the Enterprise Edition of SQL Server. Those are hard requirements., and there is absolutely no way around them. This is because the features present in the Enterprise Edition of SQL Server are simply not supported on desktop operating systems like XP. You can install the Desktop Edition or Developer Edition of SQL Server on that XP machine, but NOT the Enterprise Edition.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Michael Hotek
Applying LDF file to MDF without turning it to .BAK first?
Procedure for finding last modified info?
Migrating poorly designed database to new, normalized one
Displaying decimal places in SQL Server 2000
Creating a DTS package
Extracting data without strings converted to strange characters
Money data type conversion issue using DTS
Any way to alias a call to functions?
Repairing corrupt MDF files
In-place versus side-by-side upgrade

SQL Server installation
SQL Server consolidation: Why it's an optimization technique
SSIS error message due to installation problem on SQL Server 2005
Get SQL Server log shipping functionality without Enterprise Edition
How to create a SQL Server linked server to DB2
Tuning SQL Server performance via disk arrays and disk partitioning
Virtual database storage for SQL Server: Friend or foe?
Tutorial: Migrating to SANs from local SQL Server disk storage
How to restore SQL Server database to transition server during upgrade
Storage area network (SAN) basics every SQL Server DBA must know
Tips for moving from SQL Server local disk storage to SANs
SQL Server installation Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts