Exetools  

Go Back   Exetools > General > General Discussion

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2005, 01:00
hmora
 
Posts: n/a
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.
Reply With Quote
  #2  
Old 03-21-2005, 01:05
aldente aldente is offline
VIP
 
Join Date: Jul 2003
Posts: 266
Rept. Given: 27
Rept. Rcvd 7 Times in 5 Posts
Thanks Given: 35
Thanks Rcvd at 10 Times in 9 Posts
aldente Reputation: 7
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).
Reply With Quote
  #3  
Old 03-21-2005, 01:25
QuickeneR
 
Posts: n/a
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.
Reply With Quote
  #4  
Old 03-21-2005, 01:34
hmora
 
Posts: n/a
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
Reply With Quote
  #5  
Old 03-21-2005, 02:55
aldente aldente is offline
VIP
 
Join Date: Jul 2003
Posts: 266
Rept. Given: 27
Rept. Rcvd 7 Times in 5 Posts
Thanks Given: 35
Thanks Rcvd at 10 Times in 9 Posts
aldente Reputation: 7
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.
Reply With Quote
  #6  
Old 03-21-2005, 05:01
infern0 infern0 is offline
Friend
 
Join Date: Dec 2004
Posts: 72
Rept. Given: 4
Rept. Rcvd 0 Times in 0 Posts
Thanks Given: 0
Thanks Rcvd at 2 Times in 2 Posts
infern0 Reputation: 0
try setup.exe /k=Dk - this works fine for 7.0 version
Reply With Quote
  #7  
Old 03-21-2005, 09:21
ravendug
 
Posts: n/a
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
Reply With Quote
  #8  
Old 03-21-2005, 15:36
infern0 infern0 is offline
Friend
 
Join Date: Dec 2004
Posts: 72
Rept. Given: 4
Rept. Rcvd 0 Times in 0 Posts
Thanks Given: 0
Thanks Rcvd at 2 Times in 2 Posts
infern0 Reputation: 0
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.
Reply With Quote
  #9  
Old 03-21-2005, 16:41
duseng duseng is offline
Friend
 
Join Date: Feb 2004
Posts: 120
Rept. Given: 9
Rept. Rcvd 0 Times in 0 Posts
Thanks Given: 1
Thanks Rcvd at 2 Times in 2 Posts
duseng Reputation: 0
@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?

Last edited by duseng; 03-21-2005 at 16:45.
Reply With Quote
  #10  
Old 03-21-2005, 20:24
QuickeneR
 
Posts: n/a
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.
Reply With Quote
  #11  
Old 03-21-2005, 21:07
infern0 infern0 is offline
Friend
 
Join Date: Dec 2004
Posts: 72
Rept. Given: 4
Rept. Rcvd 0 Times in 0 Posts
Thanks Given: 0
Thanks Rcvd at 2 Times in 2 Posts
infern0 Reputation: 0
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:
Quote:
Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment.
Reply With Quote
  #12  
Old 03-27-2005, 03:22
taipan
 
Posts: n/a
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
Reply With Quote
  #13  
Old 03-27-2005, 05:42
omidgl omidgl is offline
Friend
 
Join Date: Jul 2004
Posts: 86
Rept. Given: 10
Rept. Rcvd 4 Times in 3 Posts
Thanks Given: 0
Thanks Rcvd at 5 Times in 5 Posts
omidgl Reputation: 4
Lightbulb

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
Reply With Quote
  #14  
Old 03-27-2005, 17:28
NimDa2k's Avatar
NimDa2k NimDa2k is offline
Friend
 
Join Date: Jan 2005
Posts: 124
Rept. Given: 3
Rept. Rcvd 2 Times in 1 Post
Thanks Given: 1
Thanks Rcvd at 8 Times in 5 Posts
NimDa2k Reputation: 3
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
Reply With Quote
  #15  
Old 03-28-2005, 03:55
infern0 infern0 is offline
Friend
 
Join Date: Dec 2004
Posts: 72
Rept. Given: 4
Rept. Rcvd 0 Times in 0 Posts
Thanks Given: 0
Thanks Rcvd at 2 Times in 2 Posts
infern0 Reputation: 0
NimDa2k
in installation select management tools and client connectivity
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT +8. The time now is 20:20.


Always Your Best Friend: Aaron, JMI, ahmadmansoor, ZeNiX, chessgod101
( 1998 - 2024 )