Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2008-07-26 : 11:15:51
|
| Hi,I start installing sql server 2000 enterprise on win xp, i got errorthat can't install on this operating system. I continue to installingclient tools and then install MSDE from SQL Server CD.Now that install and all features work, somebody tell me: 'You can't install enterprise version in fact You installed MSDE'- Is it true ?- If yes, what means MSDE and what can i do with it ?Regards,sasan. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-26 : 14:45:52
|
| It is true. The SQL database engine, Enterprise edition won't install on a non-server OS, so all you installed from the enterprise edition are the client tools. When you continued the installation from MSDE (Microsoft Database Engine) you got that version of the SQL database engine, not Enterprise edition.MSDE is a free, limited version of SQL 2000. It is not equivalent to enterprise edition. Databases may be no larger than 2 GB, there's a governor that throttles performance. There are other restrictions too. Can't remember them offhand.If you need the full features of Enterprise on a client workstation, look at the developer edition. It installs fine on XP and has full enterprise features. It's just not licensed for production usage (ie, you may only develop using it)--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Installing SQL Server 2000 Enterprise on XP ?