"Ágúst Valgarð" wrote:

> The error pervails...
>
> "Andrea Montanari" wrote:
>
> > Ágúst Valgarð wrote:
> > > Hi
> > > Trying to install Microsoft SQL Server 2000 Service Pack 4 on Win XP
> > > machine. MSDE 2000 Sp3 already installed on D: drive, instance name=
> > > db1
> > > In enterprise manager the db appears as ABC-111\DB1
> > > ABC-111 is the name of the machine
> > > I am using mixed authentication mode.
> > > After reading the help I came up with this to install sp4:
> > > --
> > > setup /upgradesp sqlrun instancename="db1" securitymode=sql
> > > upgradeuser=sa upgradepwd=sapw /L*v C:\MSDELog.log
> >
> > try setup /upgradesp sqlrun instancename=db1 securitymode=sql upgradeuser=sa
> > upgradepwd=sapw /L*v C:\MSDELog.log
> >
> > without quotes...
> > --
> > Andrea Montanari (Microsoft MVP - SQL Server)
> > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> > DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> > interface)
> > --------- remove DMO to reply
> >
> >
> >