MSDE

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
I have also tried having instancename="ABC-111\DB1" but always the same error:
This product is not installed. Check is a appropriate instance of MSDE is
installed.
Now, note that the MSDE is installed here on my machine:
D:\Program Files\MSDE\MSSQL$DB1
Could that possible affect this?
I noticed when I looked in the registry that I did not find what the readme
file described, still, the database has been running smoothly for months...
Any hints somebody?
gst 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.shtmhttp://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
|||The error pervails...
"Andrea Montanari" wrote:

> ágúst Valgare wrote:
> 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.shtmhttp://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
>
>
|||Sorry, my mistake, this seems to work, thank you!
"ágúst Valgare" wrote:
[vbcol=seagreen]
> The error pervails...
> "Andrea Montanari" wrote: