all groups > sql server msde > may 2007 >
You're in the

sql server msde

group:

unable to upgrade Desktop edition to SP4


unable to upgrade Desktop edition to SP4 Pete Berry
5/30/2007 10:47:42 AM
sql server msde:
OK folks -- I give up. I have a default instance installed under XP and
it is working just fine. I try to upgrade it to SP4 and consistently
get a message that says the product is not installed.

The syntax I am using is as follows:

c:\downloads\microsoft\msde\setup.exe /upgradesp sqlrun /L*v
c:\MSDELog.log (entered on one line)

I have tried both with and without the additional parameter
DISABLENETWORKPROTOCOLS=0

Also -- no log file gets created

What am I missing?
--
Graham (Pete) Berry
Re: unable to upgrade Desktop edition to SP4 Pete Berry
5/30/2007 11:33:43 AM
In article <Xns9940C1861C99AChrisCheneytesconet@80.5.182.99>,
Chris.CheneyXXNOSPAMXX@tesco.net says...
[quoted text, click to view]
Correct version, and serverproperty values are all as expected. Other
ideas?

--
Graham (Pete) Berry
Re: unable to upgrade Desktop edition to SP4 Chris.Cheney
5/30/2007 6:01:04 PM
Pete Berry <PeteBerry@Caltech.edu> wrote in news:MPG.20c7589ec3d20d29989681
@msnews.microsoft.com:

[quoted text, click to view]

You might check that your download is the MSDE version of SP4 i.e.
SQL2000.MSDE-KB884525-SP4-x86.EXE

You might also run the following

SELECT ServerProperty('InstanceName') AS InstanceName,
ServerProperty('ProductVersion') AS ProductVersion,
ServerProperty('ProductLevel') AS ProductLevel,
ServerProperty('Edition') AS Edition,
ServerProperty('Engine Edition') AS EngineEdition

Re: unable to upgrade Desktop edition to SP4 Chris.Cheney
5/31/2007 12:00:00 AM
Pete Berry <PeteBerry@Caltech.edu> wrote in
news:MPG.20c763652566b767989682@msnews.microsoft.com:

<snip>

[quoted text, click to view]

Check you have a reasonable amount of disk space free. That it didn't
create the log file is suspicious.

FWIW, the readme instructs you to

"From the command prompt, use the cd command to navigate to the folder that
contains the MSDE 2000 SP4 setup utility"

Since you specified the full path for the exe, I guess that you didn't do
Re: unable to upgrade Desktop edition to SP4 Pete Berry
5/31/2007 9:53:14 AM
In article <Xns99416C902B9D7ChrisCheneytesconet@80.5.182.99>,
Chris.CheneyXXNOSPAMXX@tesco.net says...
[quoted text, click to view]
Problem solved and the moral is -- don't always believe what someone
tells you -- verify!

MSDE != Developer edition

The particular box I am ultimately working on is MSDE but has no GUI
tools installed. The testbed I was trying to match up to it had
developer edition installed. DUH!!

Thanks -- you pointed me in the right direction
--
Graham (Pete) Berry
AddThis Social Bookmark Button