Installing SQL Server 2000 on WinXP
 

Hi,
I'm trying to install SQL server 2000 on winxp pro sp2 but the installation says that I can't install server files on my OS.

Does anyone know how can I install SQL server 2K on winXP pro SP2? I tried before installing SP2 also (with no luck).

Thanks in advance.
Hugo.

Do you want to install it for testing purposes only? Then there might be a workaround, to get it to work, otherwise I would highly recommend to install a server-OS (Windows 2000 Server or Windows Server 2003).

Try getting a Developer Edition of MS SQL. The docs say it supports the same stuff as all the other versions but it also runs happily on XP.

thanks
I'm running sql server 2k over win2k at work, but I wanted to run it at home (over XP). Do you know if any newer version of SQL server would run better on XP?
thanks again

Windows XP is definately not a server operating system. Those are heavily OPTIMIZED, so Microsoft knows, why they don't want such server applications to be installed on a workstation/consumer operating system.

But Microsoft offers "Microsoft SQL Server 2000 Desktop Engine" for free. It works on Desktop OSes, and is probably just right for what you want to do, it's power is similar to the "real" SQL Server 2000, it just has some restrictions.

try setup.exe /k=Dk - this works fine for 7.0 version

Just to confirm that Quickener is correct. Get hold of a copy of the developer edition. I'm running it myself on XP without any problems. It is supposed to be functionally equivalent to the Enterprise Edition altough my guess would be it isn't as scalable.
hxxp://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp

as i told full mssql7 has setup key to install it in developer edition mode. But you must go to root cd folder and type somth like "setup/x86/bin/setup.exe /k=Dk". I think that mssql2k have same feature.

and about functionality - in developer edition you have limited number of simulatious connections (10 or somth about). Other functions are the same.

@infern0
doesn't work!,i read something from other forum that copying setup.ins from developer edition to enterprise edition.might solve that,i have tried it seem doesn't work or i don't have proper dev edition setup.ins file?

infern0
Did you run into this limit? I didn't find in the docs any mention of connection limit in Developer. In contrast, Personal and Desktop versions are described as limited. But then again, I never had more than 1 or 2 users connected simultaneously.

duseng - pm me, i send you mine .ins As i say i didnt try 2000 with this key, coz i have developer edition version.
QuickeneR - i didnt - max i try was 3 users. btw - you right:

On XP, you can install the Desktop Engine, then upgrade it to Enterprise Server.

A little trick will be needed, because the upgrade radio button is also disabled
(greyed) in the setup, but there are several prgs, which you can help you enable it.
e.g.: "Spy & Capture" at hxxp://kobik.videodot.net/downloads/spy.zip

What you need is to setup "Microsoft Desktop Engine" (MSDE) after SQL server 2000 installation.
It's in directory "MSDE" in sql server 2000 CD. Install it and it'll work in win XP.

Of course for real working it needs a server OS. but for testing and developing, it works fine.

Regards
OMID

hi
i want to Use EnterPrise Manager witout Installing SQLSERVER . i want to Control other SQL-Server's Remotly !!!
anyone have idea about install Enterprise Manager without installing SQL Server ??

Regards
NimDa2k

NimDa2k
in installation select management tools and client connectivity