Posted by Erland Sommarskog on 08/28/06 21:48

(cjayp@yahoo.com) writes:
> I have installed SQL Sever 2000 on my Windows XP Pro machine from the
> Enterprise Edition setup and it prompts you that only the client tools
> can be installed. I wanted to have a local database as well So what
> install should I have used to do so. Any information would greatly be
> appreciated.

Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.

To have a local database on your workstation, you need to install either
Developer Edition or Personal Edition. Of these Developer Edition is
surely the better choice, as it has all the features of Enterprise
Edition. It's just the licensing which is different.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: delete sql server registration in tsql
• Prev in forum: Re: dbcc checkdb
• Thread view: Re: Installation of local database

[Reply to this message]