"Andrea Montanari" wrote:

> hi Spike,
> Spike wrote:
> > Hi,
> >
> > I'm trying to upgrade my default instance of MSDE (verified with
> > SELECT SERVERPROPERTY('Edition') ) with SQL2kSP4 using the following:
> >
> > setup /upgradesp sqlrun /L*v c:\MyLog.log
> >
> > I've tried specifying the instanceName(MSSQLSERVER) and
> > AdminUser/Password combination but whateverr I do I get:
> >
> > "This product is not installed. Check if the an appropriate instance
> > of MSDE is installed".
> >
>
> if the "original" instance of MSDE you are trying ot upgrade is the
> "default" instance, you should get the job done via the standard
> c:\..\>setup.exe /upgradesp SQLRUN <further_params_if_required> /L*c
> "c:\mylog.txt"
> where named instances require the additional INSTANCENAME=xx parameter like
> c:\..\>setup.exe /upgradesp SQLRUN INSTANCENAME=the_instance_name
> <further_params_if_required> /L*c "c:\mylog.txt"
>
> personally I usually provide additional parms as well, like
> c:\..\>setup.exe /upgradesp SQLRUN INSTANCENAME=the_instance_name
> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 REINSTALL=ALL UPGRADEUSER=user
> UPGRADEPWD=pwd /L*c "c:\mylog.txt"
> as required/desired..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> --------- remove DMO to reply
>
>